1

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

Improve this question

1 Answer 1

Reset to default
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.

Improve this answer
5
  • 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, 2012 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, 2012 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, 2012 at 18:13
  • It's actually different if you have already created your database user or not. Here you may find some information how to create it properly.
    – Vladimir Blaskov
    Jun 25, 2012 at 18:24
  • Can you provide some links? Ive created database and user.
    – Ultra
    Jun 25, 2012 at 18:35

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .