navicat连接数据库报错:
1130-host … is not allowed to connect to this MySql server
解决:
1. 连接服务器: mysql -u root -p
2. 输入密码后登录到mysql中
3. 查看所有数据库: show databases;
4. 进入mysql数据库: use mysql;
5. 查看mysql数据库中的表: show tables;
6. 查看user表中的host.user数据 : select Host, User from user;
7. 修改user表中的Host: update user set Host='%' where User='root';
8. 最后刷新一下: flush privileges;
完成,但是也有可能报错:1251 Client does not support authenticasider upgrading Mysotocol requested by ser
则跳转至:https://blog.csdn.net/weixin_43097301/article/details/85892142
修改一下即可成功连接数据库