mysql - 无法设置对 MySQL 服务器的外部访问

Question

我正在尝试允许外部访问 MySQL 服务器。首先，我将 my.cnf 更改为此(my.cnf 的一部分): [mysqld_safe] 套接字=/var/run/mysqld/mysqld.sock 不错 = 0

[mysqld]
#
# * Basic Settings
#
user            = mysql
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
port            = 3306
basedir         = /usr
datadir         = /var/lib/mysql
tmpdir          = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking
#
# 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

在/etc/hosts.allow 中我添加了: mysqld: 全部

我还添加了用户 'root'@'%'，但我所拥有的是:我正在尝试使用外部主机名从一个服务器连接到另一个服务器:

root@******:~# mysql -h******.com -u root -p
ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 0

但是使用 'localhost' 一切都很好: root@******:~# mysql -hlocalhost -u root -p

MySQL 服务器版本:5.5.43Ubuntu 14.10 (GNU/Linux 3.16.0-23-generic x86_64)

Answer 1

您应该在创建用户后运行命令-

GRANT ALL ON dbname.* TO 'root'@'%' IDENTIFIED BY 'root';
FLUSH HOSTS; 
FLUSH PRIVILEGES;

如果你已经运行了这段代码那么可能是防火墙问题-