The user specified as a definer ('reporter'@'172.16.0.%') does not exist
来源:互联网 发布:耳机音频测试软件 编辑:程序博客网 时间:2024/05/16 11:50
使用mysql数据库时,遇到以下报错:
The user specified as a definer ('reporter'@'172.16.0.%') does not exist.
解决方案:
1、检查数据库配置文件
2、检查sql,视图或者存储过程的用户可能不对,删除重建
数据库测试环境的用户与线上环境的用户不同,所以在导入存储过程和视图时要注意。
0 0
- The user specified as a definer ('reporter'@'172.16.0.%') does not exist
- The user specified as a definer (@'''') does not exist
- The user specified as a definer ('root'@'%') does not exist。
- The user specified as a definer ('root'@'%') does not exist
- The user specified as a definer ('root'@'%') does not exist。 .
- The user specified as a definer ('root'@'%') does not exist。
- The user specified as a definer ('XXXXX'@'%') does not exist
- The user specified as a definer ('root'@'%') does not exist
- The user specified as a definer ('monitor'@'%') does not exist
- The user specified as a definer (''@'') does not exist
- The user specified as a definer ('montor'@'%') does not exist
- The user specified as a definer ('test'@'%') does not exist
- The user specified as a definer ('root'@'%') does not exist
- The user specified as a definer ('root'@'%') does not exist
- The user specified as a definer ('root'@'%') does not exist
- The USER specified AS a DEFINER ('lingshi'@'%') does NOT exist
- The user specified as a definer ('root'@'%') does not exist
- The user specified as a definer (''@'%') does not exist
- oracle用户创建及权限设置
- Axis2
- 浅析Hash算法
- SOAP webserivce 和 RESTful webservice 对比及区别
- RAID详解
- The user specified as a definer ('reporter'@'172.16.0.%') does not exist
- [JZSC2016]【NOIP2016A组模拟7.13】总结
- Redis配置文件参数说明
- Android wifi无线调试App新玩法ADB WIFI
- 链接中的符号
- iOS 修改项目的桌面名称
- android 双service和双进程
- Table边框使用总结
- Android跑马灯两种方式