Host '127.0.0.1' is not allowed to connect to this MySQL server
程序员文章站
2023-12-22 23:57:46
...
错误:Host '127.0.0.1' is not allowed to connect to this MySQL server
一般原因: MySQL数据库的配置文件my.ini中设置了参数: skip-name-resolve
从而导致使用“localhost”不能连接到数据库。
解决方法: 注释掉: #skip-name-resolve
注释掉对数据库的设置略有影响,但影响不大。
一般原因: MySQL数据库的配置文件my.ini中设置了参数: skip-name-resolve
从而导致使用“localhost”不能连接到数据库。
解决方法: 注释掉: #skip-name-resolve
注释掉对数据库的设置略有影响,但影响不大。
以上就是Host '127.0.0.1' is not allowed to connect to this MySQL server的详细内容,更多请关注其它相关文章!
推荐阅读
-
MYSQL不能从远程连接的一个解决方法(s not allowed to connect to this MySQL server)
-
MYSQL不能从远程连接的一个解决方法(s not allowed to connect to this MySQL server)
-
Mysql远程连接 Host * is not allowed to connect to this MySQL server
-
远程连接MariaDB报错——1130 - Host '192.168.64.1' is not allowed to connect to this MariaDB server
-
MySQL 1130 - Host 127.0.0.1 is not allowed to connect to this MySQL server
-
Navicat 连接 MySQL 失败 : 1130 - Host xxx is not allowed to connect to this MySQL server
-
MYSQL Error 1130:Host '计算机名' is not allowed to connect to this MySQL server
-
转:mysql远程连接 Host * is not allowed to connect to this MySQL server
-
MySQL安装提示错误Host '127.0.0.1' is not allowed to connect to this MySQL server
-
mysql数据库错误ERROR 1130:Host '' is not allowed