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!
5
-
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.– gparentMay 2, 2012 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 LopezMay 2, 2012 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.– gparentMay 2, 2012 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)– gparentMay 2, 2012 at 15:15
-
No problem, make sure to mark my answer as accepted if you find the file and the parameter worked.– gparentMay 3, 2012 at 14:01
Add a 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.
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
