Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I want to update some data to a MySQL remote server. I have conexion between the server and the client through VPN and it works. But I can't manage server's databases from the client. I've read that I need to modify the file 'my.cnf' and write in 'bind-adress' Client's IP. That's correct?? I can not find this file in the server. I'm using windows 7 in both machines and I have installed MySQL server 5.5. Thank you!

share|improve this question
Are you sure bind-address has anything to do with this? Seems like an option to specify what addresses your server will be listening on, which would definitely not be your client's IP. – gparent May 2 '12 at 15:02
I've read it in some forums. the people have solved this problem, changing the bind adress for (mysql interface) or client's IP. However, most of them uses Lynux. The point is Mysql server is configured to don't allow external management, I should reconfigure something. I thougth that was bin-adress – David Lopez May 2 '12 at 15:12
It is, but you need to read the man pages again.… will tell you how to set it up. Essentially you want your server to listen on its external interfaces as well as the loopback in order for your client to be able to connect. – gparent May 2 '12 at 15:15
Also you might have to change the allowed hosts of the username you are going to be logging in with (normally they are set to localhost or since the web server often runs on the same machine as the database for small scale deployments) – gparent May 2 '12 at 15:15
Thanks, I'll read it!! – David Lopez May 2 '12 at 15:28

You can find information here about searching for files in Windows 7. Simply use 'my.cnf' as the file name and you will know where it is located.

share|improve this answer

You should look for it in the folder where you installed MySQL (C:\Program Files\MySQL [version]), or in the subfolder "etc"

If not, check C:\Windows\my.cnf or my.ini

If not, check C:\my.cnf


share|improve this answer
Thank you, there is my.ini file !! Not my.cnf – David Lopez May 2 '12 at 15:21

Your Answer


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.