Monthly Archives: November 2018

mysql Port 3306 Ubuntu server all ip connet

configuration file in the terminal,

I fixed this by changing bind-address 127.0.0.1 to bind-address 0.0.0.0 in /etc/mysql/mysql.conf.d/mysqld.cnf,  (so that MySQL listens on all ports).

sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf
 bind-address 127.0.0.1 to bind-address 0.0.0.0

save file   exit and restart mysql 

/etc/init.d/mysql restart 

OK Work