1

In my.cnf file I can find #bind-address = 127.0.0.1. Is changing it to bind-address = % will do the job?

Ultra
  • 21

1 Answers1

4

If the bind-address and skip-networking options are not specified, MySQL listens by default on all interfaces, so you should just make sure that those 2 options are commented.

You can also force MySQL to listen on all interfaces explicitly by specifying:

bind-address = 0.0.0.0

If you want to make it to listen to only 1 IP address, you can do this by:

bind-address = your.ip.addr.ess

You can also check this thread for more information.

Community
  • 1
Vladimir Blaskov
  • 6,373