The user specified as a definer ('res'@'%') does not exist 解决方法
来源:互联网 发布:java主方法入口 编辑:程序博客网 时间:2024/05/20 05:54
工具:mysql5.5
The user specified as a definer (‘res’@’%’) does not exist
意思是某个数据库对象的定义者(也就是’res’@’xxxxx’ )不存在
原来是导出并恢复数据库时,视图的定义者还是原来的用户:’res’ ,
但是本地数据库并没有res这个用户,只有root用户,所以只要将视图的定义者修改为root即可解决问题。
授权 给 res 所有sql 权限
grant all privileges on *.* to res@"%" identified by ".";flush privileges;
0 0
- The user specified as a definer ('res'@'%') 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
- VC里的编码问题
- 提高篇第20-21课第三题
- 旋转数组的最小数字
- HashMap的工作原理及性能分析
- 跨进程调用Service(AIDL Service)流程2(复杂数据)
- The user specified as a definer ('res'@'%') does not exist 解决方法
- 凯云水利水电工程造价管理系统 MVC框架的搭建(一)
- 关于expdp的几个小问题
- 关于新浪微信瘦身的问题
- mysql sql 语句插入 blob字段的插入
- Perforce warning:Can't clobber writable file ...
- Spring之AOP模块
- Python 之 使用 PIL 库做图像处理
- Win7如何取消Windows启动管理器