问题原文
原帖链接 · ozahorulia · CC BY-SA 3.0
I have always successfully set up a remote connection for MySQL 5.5.
Today I installed a new server with Ubuntu 16.04 and MySQL 5.7. But for some reasons, I can't make this MySQL installation listen to other hosts but 127.0.0.1.
Here is my /etc/mysql/conf.d/mysql.cnf:
[mysqld]
bind-address = 0.0.0.0
I couldn't connect to this MySQL server from a remote host, and when I checked my netstat, I realized that MySQL listens to connections from localhost only.
lsof -Pni :3306 output is:
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
mysqld 5302 mysql 25u IPv4 37280 0t0 TCP 127.0.0.1:3306 (LISTEN)
What is the problem?
已采纳解答
原帖链接 · Linuxx · CC BY-SA 3.0
They changed the MySQL package so that the bind parameter is in /etc/mysql/mysql.conf.d/mysqld.cnf now. Please change the bind parameter there and remove anything you placed in /etc/mysql/conf.d/mysql.cnf.
摘自公开归档,保留原文语言,版式经整理,外部媒体与邮箱地址已移除。
