Posts Tagged ‘connection’

MySQL – Listen to localhost and network connections

March 26th, 2010

With MySQL you sometimes need to listen to localhost and network connections.

To allow it to do this is fairly simple.

Edit the file


and find the line bind-address. It should look like :

bind-address =  <-- this allows only localhost connections

To allow all types of connections, localhost, network and general, change it to:

bind-address =

If you want it to only connect from the local network

bind-address =

(or whatever the local address is )

to connect from the internet only, bind to the external IP.

You will still need to make sure that the user still has the proper permissions to connect to the mysql DB

if you found this helpful feel free to donate to:
ZEC: t1NQp1UuqQbmnXzazbLTSreS2AbaZpRBuTM
LTC: LZyNF1qkBUA7XFz83m5xwzGgmmj1owQn9d