错误1130(HY000):不允许主机''连接到该MySQL服务器

问题描述

为什么哦，为什么我不能连接到mysql?

Why oh why can I not connect to mysql?

mysql -u root -ptest101 -h xxx.xxx.xxx.xxx
ERROR 1130 (HY000): Host 'xxx.xxx.xxx.xxx' is not allowed to connect to this MySQL server

在my.cnf中，我有以下内容

In my.cnf I have the below

# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address        = 0.0.0.0

我还运行了以下内容...

I also ran the below...

'UPDATE mysql.user SET Password = PASSWORD('test101') WHERE User = 'root';
FLUSH PRIVILEGES;

我可以使用mysql -u root -ptest101在主机上访问，但不能使用mysql -u root -ptest101 -h xxx.xxx.xxx.xxx

I can access on the host machine using mysql -u root -ptest101 but not using mysql -u root -ptest101 -h xxx.xxx.xxx.xxx

哇...为什么会这样?我是Ubuntu 12.04

Wow...why is this happening? I am n ubuntj 12.04

mysql> SELECT host FROM mysql.user WHERE User = 'root';
+---------------------------------------------+
| host                                        |
+---------------------------------------------+
| %                                           |
| 127.0.0.1                                   |
| ::1                                         | |
| localhost                                   |
+---------------------------------------------+
5 rows in set (0.00 sec)

推荐答案

您的root帐户，并且此语句适用于任何帐户，可能仅添加了具有localhost访问权限(建议).

Your root account, and this statement applies to any account, may only have been added with localhost access (which is recommended).

您可以使用以下方法进行检查:

You can check this with:

SELECT host FROM mysql.user WHERE User = 'root';

如果仅使用localhost和127.0.0.1查看结果，则无法从外部来源进行连接.如果您看到其他IP地址，但没有看到您要从其连接的IP地址-这也表明.

If you only see results with localhost and 127.0.0.1, you cannot connect from an external source. If you see other IP addresses, but not the one you're connecting from - that's also an indication.

您需要添加要授予访问权限的每个系统的IP地址，然后授予特权:

You will need to add the IP address of each system that you want to grant access to, and then grant privileges:

CREATE USER 'root'@'ip_address' IDENTIFIED BY 'some_pass';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'ip_address';

如果您看到%，那么，还有另一个问题，那就是任何远程源".但是，如果您确实希望任何/所有系统都通过root连接，请使用%通配符授予访问权限:

If you see %, well then, there's another problem altogether as that is "any remote source". If however you do want any/all systems to connect via root, use the % wildcard to grant access:

CREATE USER 'root'@'%' IDENTIFIED BY 'some_pass';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';

最后，重新加载权限，您应该可以进行远程访问:

Finally, reload the permissions, and you should be able to have remote access:

FLUSH PRIVILEGES;

这篇关于错误1130(HY000):不允许主机''连接到该MySQL服务器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！