Friday, 3 January 2014

Allow remote connection to mysql

1. Comment out the line here if any in file /etc/my.conf
#bind-address = 127.0.0.1

2. Restart mysql

3. Login mysql
mysql>GRANT ALL PRIVILEGES ON *.* TO username@ipaddress IDENTIFIED BY "password";

No comments: