navicat 远程连接mysql数据库报错1130的解决办法

1.登陆到数据库 mysql -u root -p
2.输入:use mysql;
3.输入:update user set host = '%' where user = 'root' and host='localhost';
4.输入查看:select host, user from user;
5.保存:mysql>flush rivileges
6.退出后重启:service mysql restar

点赞

发表回复