在用Navicat连接本地数据库时报错,Navicat连接本地MySQL数据库报错:1130 - Host 'localhost' is not allowed to connect to this MySQL server,翻译成中文的意思就是:1130-不允许主机“localhost”连接到此MySQL服务器。 ![](/Images/JiaoCheng/NeiRong/20220522/1653188639807365.png)
(Navicat连接localhost主机报错)
在用Navicat连接本地数据库时报错:1130 - Host 'localhost' is not allowed to connect to this MySQL server (1130-不允许主机“localhost”连接到此MySQL服务器) 解决方法:“主机”后面输入框填写:127.0.0.1即可连接成功! ![](/Images/JiaoCheng/NeiRong/20220522/1653188913532789.png)
(Navicat改为127.0.0.1主机连接成功)
![](/Images/JiaoCheng/NeiRong/20220522/1653189300845675.png)
以上就是解决在用Navicat连接本地数据库时报错:1130 - Host 'localhost' is not allowed to connect to this MySQL server方法了 |