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
  • 3

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,073
  • 1
  • 26
  • 22
  • Its for my gameserver which stands on the same machine along with MySQL. Is it nesesary to even open it? Becaouse my previous host told me that he had to open it with "%". – Ultra Jun 25 '12 at 17:29
  • If your game server is on the machine, you won't need to open configure MySQL to accept external connections. However you may need to tweak the hosts that your user is allowed to connect from. – Vladimir Blaskov Jun 25 '12 at 17:31
  • - However you may need to tweak the hosts that your user is allowed to connect from - How to do it? – Ultra Jun 25 '12 at 18:13
  • It's actually different if you have already created your database user or not. [Here](http://dev.mysql.com/doc/refman/5.1/en/adding-users.html) you may find some information how to create it properly. – Vladimir Blaskov Jun 25 '12 at 18:24
  • Can you provide some links? Ive created database and user. – Ultra Jun 25 '12 at 18:35