MySQL Remote connection

Error: ERROR 2003 (HY000): Can’t connect to MySQL server on ‘192.168.1.6’ (10061)

Solution:

1. make sure comment below line within /etc/mysql/my.cnf

#bind-address = 127.0.0.1

2. “sudo service mysql restart” to restart mysql.

3. grant all on *.* to username@’%’ identified by ‘password’ with grant option;

Leave a Reply

Your email address will not be published. Required fields are marked *