通过Navicat for MySQL远程连接的时候报错mysql 1130的解决方法

给用户授权

我用的用户是root 密码123456

首选语法为:
Sql代码
GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;

示例:
Sql代码
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;

执行完后,再
mysql> flush privileges;
刷新一下权限就可以了,不用重启

mysql -u root -p 123456;
mysql > GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
mysql > flush privileges;