Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

share|improve this question

1 Answer 1

up vote 4 down vote accepted

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.

share|improve this answer
    
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 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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.