Make MySQL listen on other interfaces

Written by
Date: 2015-05-18 07:24:32 00:00

Spanish

How to make MySQL listen on other interfaces?

If you want to change the default behaviour of MySQL that only listen on localhost (127.0.0.1) and make it aviable from the outside Network. You need to edit file /etc/mysql/my.cnf and look for this line bind-address = 127.0.0.1 and make it look like this one:

#bind-address     = 127.0.0.1

That is comment it out. Then restar the server.

sudo service mysql restart