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
Here is my
[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
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?