mysql提示The user specified as a definer ('root'@'%') does not exist

如果你的mysql提示The user specified as a definer ('root'@'%') does not exist错误这个肯定是授权问题了，我们只要简单的处理一下即可。

重装了mysql,项目运行遇到该异常,记录一下解决的办法:

1、登录mysql

2、执行赋权限操作,然后刷新权限.

mysql >grant all privileges on *.* to root@"%" identified by "Passwd" ;

mysql >flush privileges;

其实这种问题相对来说见得比较少了,因为mysql安装之后root权限就比较高了.

·mysql保存查询数据提示:specified twice错误解决办法(2014-10-08)
·Mysql出现Field * doesn't have a default value(2014-10-02)
·MySQL无法启动：Table mysql.host doesn t exist(2014-10-09)
·mysql中FUNCTION xxx.LEN does not exist错误(2014-10-12)
·mysql提示service mysql3306 does not support chkconfig错误(2015-04-20)

相关文章