已解决:通过NavicatforMysql连接数据库出现错误1449-The user specified as a definer(‘‘) does not exist
mysql 登录报错1449-The user specified as a definer(‘mysql.infoschema‘@localhost‘) does not exist:
·
错误信息:
mysql 登录报错1449-The user specified as a definer(‘mysql.infoschema‘@localhost‘) does not exist
解决方法:
- 1.进入mysql:
mysql -u root -p
- 2.删除之前的视图表:
drop user `mysql.infoschema`@"localhost";
- 3.刷新权限:
flush privileges;
- 4.创建缺少的视图表:加粗样式
create user `mysql.infoschema`@"localhost" identified by '123456';
- 5.再刷新权限:
flush privileges;
- 6.使用数据库:
use mysql;
- 7.设置权限:
update user set Select_priv = 'Y' where User = 'mysql.infoschema';
- 8.刷新权限:
flush privileges;
最后再次进行Navicat for Mysql的连接就可以成功了!
更多推荐
已为社区贡献1条内容
所有评论(0)