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.

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 127.0.0.1 (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. dev.mysql.com/doc/refman/5.5/en/… 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 127.0.0.1 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
show 1 more comment

2 Answers

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
add comment

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

reference

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

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.