Monday, May 26, 2014

Unable to access MySql Server DB remotely

By default, MySql Server DB cannot be connected remotely. To expose MySQL DB other than localhost you will have to un comment the following line in /etc/mysql/my.cnf and assign your computer's IP address and not loopback IP.

bind-address = 127.0.0.1

Comment it out by adding a hash (#) at the front:

#bind-address = 127.0.0.1

Add your computer's IP address:

bind-address = 192.168.xxx.xxx

Restart MySql:

$ /etc/init.d/mysql restart

No comments:

Post a Comment