1. Try to telnet the remote mysql server.
e.g. telnet 192.168.1.2 3306 (Windows)
e.g. telnet 192.168.1.2 3306 (Linux)
2. If not being able to telnet, check the config file of mysql (my.cnf). "bind-address" parameter should be set to ip address and not to localhost.
3. Restart the mysql service.
4. Now you should be able to telnet and also connect to the mysql server remotely.
Resources used:
http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html
http://ubuntuforums.org/showthread.php?t=687294
Sunday, December 28, 2008
Subscribe to:
Posts (Atom)
