MySQL: Host '127.0.0.1' is not allowed to connect to this MySQL server

最新推荐文章于 2025-06-16 15:33:11 发布

原创最新推荐文章于 2025-06-16 15:33:11 发布 · 9.1k 阅读

2 ·

CC 4.0 BY-SA版权

文章标签：

#127.0.0.1 #localhost #mysql #MySQL #Mysql #MYSQL #MySql

本文解决了一个常见的MySQL连接问题，即主机'127.0.0.1'不允许连接到MySQL服务器。通过调整MySQL配置文件（/etc/my.cnf）中的skip-name-resolve设置，使数据库能够正常接受来自localhost的连接。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

MySQL连接数据库出现错误：Host '127.0.0.1' is not allowed to connect to this MySQL server

实际访问数据库配置：jdbc.url=jdbc:mysql://localhost:3306/*****

实际数据设置为只允许localhost访问，经检查发现是MySQL配置文件（/etc/my.cnf）中设置了skip-name-resolve，注释之后可以正常访问

确定要放弃本次机会？

福利倒计时

: :

立减 ¥

普通VIP年卡可用

立即使用

liuyan4794

关注关注

0
点赞
踩
2

收藏

觉得还不错? 一键收藏
0
评论
分享

复制链接

分享到 QQ

分享到新浪微博

扫一扫
举报

举报

解决Mysql benchwork连接错误，Host ‘127.0.0.1‘ is not allowed to connect to this MySQL server

qq_39578356的博客

07-22

2345

MySQL workbench 连接数据库出现错误：Host '127.0.0.1' is not allowed to connect to this MySQL server

解决1130 - Host ‘172.17.0.1‘ is not allowed to connect to this MySQL server 密码乱码 8.0.1}VV\NZ#m＞fa＜

nongcunqq的博客

06-20

351

更改身份验证插件：将 MySQL 默认身份验证插件从 caching_sha2_password 改为 mysql_native_password。2、启动mysql容器：docker run --name mysql -p 3306:3306 -e MYSQL_ROOT_PASSWORD=123456 -d mysql。6、连接mysql数据库：docker exec -it mysql bash。7、连接服务器: mysql -u root -p。9、进入mysql数据库：use mysql;

参与评论您还未登录，请先登录后发表或查看评论

MySQL 1130 - Host 127.0.0.1 is not allowed to connect to this MySQL server

weixin_34066347的博客

06-09

491

在开发中为了让开发更方便,在本地配置环境，希望可以直接访问服务器上的MySQL数据库，更方便的管理数据库，需要在本地远程连接linux服务器的本地数据库，直接用数据库管理工具连接出现如下报错1130 - Host 127.0.0.1 is not allowed to connect to this MySQL server：这个错误说明MySQL没有允许远程登录，只要授权可以远程登录就o...

连接mysql提示 ‘xxx.xxx.com‘ is not allowed to connect to this MySQL serverConnection closed by

最新发布

努力学习中

06-16

693

is not allowed to connect to this MySQL serverConnection closed by foreign host.

Host '127.0.0.1' is not allowed to connect to this MySQL server

dddp75921的博客

06-22

662

错误：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#ERROR 1130: Host ‘127.0.0.1‘ is not allowed to connect to thisMySQL serve

风火燎原、

06-21

1338

错误：ERROR 1130: Host ‘192.168.1.3’ is not allowed to connect to thisMySQL serve 错误1130：主机192.168.1.3”不允许连接到thismysql服务原因：被连接的数据不允许使用 192.168.1.3访问，只允许是用 localhost; 解决办法：可能是你的帐号不允许从远程登陆，只能在localho...

MYSQL拒绝访问报错not allowed to connect

12-15

message from server: “Host ‘****’ is not allowed to connect to this MySQL server 1:在登录mysql服务器 2:执行：GRANT ALL PRIVILEGES ON *.* TO ‘root’@’%’ WITH GRANT OPTION //赋予任何主机访问数据的...

ERROR 1130 (HY000): Host localhost is not allowed to connect to this MySQL server

07-25

3. MySQL 配置问题：请检查 MySQL 服务器的配置文件（通常是 my.cnf 或 my.ini），确保绑定地址设置为 localhost 或 127.0.0.1。您可以查找以下行并进行相应的更改： ``` bind-address = localhost ``` 更改后...

ERROR 1130 (HY000): Host '127.0.0.1' is not allowed to connect to this MySQL server

06-08

原因是MySQL服务器不允许来自127.0.0.1的主机连接。要解决这个问题，你需要在MySQL服务器上进行以下操作： 1. 登录MySQL服务器。 2. 运行以下命令： GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '...

127.0.0.1’ is not allowed to connect to this MySQL serverConnection closed by foreign host

OnePiece

12-16

2868

telnet本地mysql的端口号时报 ‘XXX’ is not allowed to connect to this MySQL serverConnection closed by foreign host 解决方法： 1. 改表法。可能是你的帐号不允许从远程登陆，只能在localhost。这个时候只要在localhost的那台电脑，登入my

‘127.0.0.1’ is not allowed to connect to this MySQL serverConnection closed by foreign host

kunatnet的专栏

05-13

1万+

telnet本地mysql的端口号时报 ‘XXX’ is not allowed to connect to this MySQL serverConnection closed by foreign host

mysql报错：Host is not allowed to connect to this MySQL server(设置远程连接)

enthan809882的博客

11-24

1046

一般出现在，localhost可以连接mysql，但是远程不行。输入shell命令： mysql -u root -p #然后输入密码进入mysql mysql命令行输入： use mysql; update user set host = '%' where user = 'root'; flush privileges; 发现可以连接了。 ...

mysql 1130错误 Host '127.0.0.1' is not allowed to connect to this

tongle_deng的专栏

04-17

9834

错误：Host '127.0.0.1' is not allowed to connect to this MySQL server 一般原因： MySQL数据库的配置文件my.ini中设置了参数： skip-name-resolve 从而导致使用“localhost”不能连接到数据库。解决方法：注释掉： #skip-name-resolve

pymysql.err.InternalError: (1130, "Host '127.0.0.1' is not allowed to connect to this MySQL server")

微电子学与固体电子学-俞驰

01-11

3183

首先采用[1]: mysql -u root -p mysql>use mysql; mysql>select 'host' from user where user='root'; mysql>update user set host = '%' where user ='root'; mysql>flush privileges; 然后采用 mysq...

不能连接到mysql服务器127.0.0.1,MySQL主机':: 1'或'127.0.0.1'不允许连接到该MySQL服务器...

weixin_32216791的博客

01-19

561

I have a strange issue on a web server (Windows Server 2012) with MySQL 5.7.16.I can't connect anymore to mysql server, I don't know why.If I type mysql -uroot -ppassword appear an errorERROR 1130 : ...

远程连接MYSQL提示Host is not allowed to connect to this MySQL server