Host ‘IP’ is not allowed to connect to this MySQL server
在用Navicat远程连接Mysql数据库时遇到如下报错信息,因为当前账号不支持远程连接
1.首先在系统中登录mysql
mysql -u root -p
2.执行执行命令:
use mysql;
select host from user where user='root';
flush privileges;
3.再次使用Navicat连接MySql
...
原创
2020-06-18 10:13:12 ·
201 阅读 ·
0 评论