MySQL – Listen to localhost and network connections

March 26th, 2010 by admin Leave a reply »

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

Leave a Reply

You must be logged in to post a comment.