用主机Natcivat连接服务器Mysql,出现错误提示:1130-Host‘XXX.XXX.XXX.XXX’ is not allowed to connect to this MySQL server
原因:远程服务器无权限登录MySQL
解决:
1.Ubuntu下登录MySQL:mysql -uroot -p
2.执行下命令
GRANT ALL PRIVILEGES ON *.* TO ‘你的用户名’@’%’ IDENTIFIED BY ‘你的数据库密码’ WITH GRANT OPTION;
3.在执行下
flush privileges;
这个命令是刷新一下权限,不用重启
以上只针对5.7以下版本。
5.7以上执行的时候会报错误
- mysql> GRANT ALL PRIVILEGES ON *.* TO ‘XXX’@’%’ IDENTIFIED BY ‘ZZZZZ’ WITH GRANT OPTION;
- ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
- mysql> exit
mysql> GRANT ALL PRIVILEGES ON *.* TO 'XXX'@'%' IDENTIFIED BY 'ZZZZZ' WITH GRANT OPTION;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
mysql> exit
这个时候,需要先执行刷新权限:
flush privileges;