The user specified as a definer ('root'@'%') does not exist解决方法
来源:互联网 发布:mac phpstorm 破解 编辑:程序博客网 时间:2024/06/03 16:36
今天从服务器数据库备份到自己电脑的时候,发现备份的视图打不开了,提示The user specified as a definer ('root'@'%') does not exist。
然后去启动mysql命令窗口,发现不能用,去本地服务上找,发现本地服务上找不到mysql服务了。我的数据库版本是5.5的 解决方法:D:\Program Files\MySQL\MySQL Server 5.5\bin>mysqld.exe -install
接着就可以再本地服务上看到mysql了,然后启动mysql.在mysql命令窗口上
mysql> grant all privileges on *.* to root@"%" identified by ".";
Query OK, 0 rows affected (0.00 sec)mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
问题解决!!
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
- 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 解决方法
- mysql 1449 : The user specified as a definer ('root'@'%') does not exist 解决方法
- Jquery ajax异步请求带来的问题及解决方案
- 把1分解为若干个互不相同的单位分数之和
- iOS应用程序生命周期(前后台切换,应用的各种状态)详解
- Oracle基本数据类型存储格式浅析(一)——字符类型
- c#数据格式化之DataFormatString
- The user specified as a definer ('root'@'%') does not exist解决方法
- Hadoop操作笔记--命令大全 .
- hdu 4513 吉哥系列故事——完美队形II ( manacher+dp )
- .htaccess使用详解
- 转载的计算大数的阶乘
- Windows 开发人员中心-桌面-入门-选择技术
- 单例模式
- [LeetCode] 032. Longest Valid Parentheses (Hard) (C++)
- 一条SQL语句面试题:求选修所有课程的学生