关于The user specified as a definer ('root'@'%') does not exist 解决方法
来源:互联网 发布:韩顺平java全套视频 编辑:程序博客网 时间:2024/05/17 22:50
解决办法:
第一种:给root赋值所有权限:注意在命令符下面操作.
授权 给 root 所有sql 权限
Mysql—>grant all privileges on *.* to root@”%” identified by “.”;
重新加载权限
Mysql—>flush privileges;
但是这种重启之后一会就又不行的话。
第二种:
复制视图创建语句,直接将create改成alter,definer改成相关的,比如root@localhost 例如:
用alter view 修改definer的值,alter ALGORITHM=UNDEFINED DEFINER=`public`@`192.168.0.%`
SQL SECURITY DEFINER VIEW `view_product` AS 视图选择语句。
原因分析:
因为创建视图使用的是xff@%用户(目前已经不存在),然后登录用户使用的是xff@localhost用户,
导致mysql认为现在的用户无权限访问该视图,解决方法就是在当前用户下重建该视图。
阅读全文
0 0
- 关于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 ('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 ('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 ('root'@'%') does not exist
- The user specified as a definer ('root'@'%') does not exist
- mySql问题:The user specified as a definer ('root'@'%') does not exist 解决方法
- mysql 1449 : The user specified as a definer ('root'@'%') does not exist 解决方法
- mysql 1449 : The user specified as a definer ('root'@'%') does not exist 解决方法
- mysql 1449 : The user specified as a definer ('root'@'%') does not exist 解决方法
- Sublime Text 3 import Anaconda 无法正常补全模块名解决办法
- 面试题 31:连续子数组的最大和(滴滴的“连续最大和”)
- Logistics Rrgression(Logistics回归)
- JAVA 反射机制(Java Reflection)总结(二)
- hdu 5976 Detachment(乘法逆元)(附测试用例)
- 关于The user specified as a definer ('root'@'%') does not exist 解决方法
- block与inline 元素
- hdu 1124 圆桌会议
- MFC中有三种文件操作的类 CFile ,CArchive,CDocument
- 【Angular2】插值表达式如何嵌套显示
- 基础算法(二分,去重,排列)
- 后台管理布局之模板继承2 补充 继承拼接
- Arctic Network POJ
- Python 变量类型