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