navicat远程连接mysql出现1130的错误

来源：互联网发布：百视通网络电视下载编辑：程序博客网时间：2024/06/05 03:46

用主机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以上执行的时候会报错误

[plain] view plain copy

print?

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

这个时候，需要先执行刷新权限：

[plain] view plain copy

print?

flush privileges;

flush privileges;

阅读全文

0 0