Connect to MySQL remotely - Shuang0420/Shuang0420.github.io GitHub Wiki
Error
ERROR 2003 (HY000): Can't connect to MySQL server on '10.118.44.4' (61)
Solution
Step1:
- open config file
vim /etc/mysql/my.cnf - comment
bind-address = 127.0.0.1 - restart mysql
service mysql restart
Step2:
mysql> GRANT ALL PRIVILEGES ON *.* TO root@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES;