遠程連接MySQL報錯ERROR 2003解決辦法

在mysql遠程連接時出現ERROR 2003錯誤的很多種，下面我來給大家介紹兩種解決此問題的方法，有需要的同學可參考。

問題代碼代碼

ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.0.19' (111)
ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.0.19' (111) 這個 原因就是Mysql數據庫的默認配置文件my.cnf（linux下）中的bind-address默認為127.0.0.1，所以就算你創建了可以 remote訪問的用戶，你也不能使用mysql -h命令進行訪問，若訪問就會出現上出問題，因為此時Mysql只接受localhost，所以需要把bind-address屏蔽掉。
my.cnf一般在/etc/mysql下面，如果不在使用locate my.cnf查找，修改前的my.cnf配置文件為：
修改前的my.cnf配置文件代碼
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address = 127.0.0.1
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address = 127.0.0.1
我們需要做的就是屏蔽這個bind-address代碼，屏蔽後代碼為：
屏蔽後my.cnf配置文件代碼
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
#bind-address = 127.0.0.1
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
#bind-address = 127.0.0.1
現在你就可以用mysql -h命令進行你想做的操作了，如登錄系統：
登陸數據庫代碼
mysql -h 192.168.0.19 -u root -p

如果上面還不能解決可能是防火強的問題了

1.mysql 錯誤 ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost'
    

解決辦法：關閉防火牆，安陽電腦網，linux下命令

[root@etl01 bin]# chkconfig --list | grep -i iptables  ====check fire wall

iptables        0:off   1:off   2:on    3:on    4:on    5:on    6:off

[root@etl01 bin]# /sbin/service iptables stop           ====stop fire wall

Flushing firewall rules: [  OK  ]

Setting chains to policy ACCEPT: nat filter [  OK  ]

Unloading iptables modules: [  OK  ]

 

2.報錯:1130-host ... is not allowed to connect to this MySql server

 

解決辦法：

 

授權形式

比如賬戶為root,密碼為root

use mysql;

用root賬戶從任何主機上訪問mysql數據庫了

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;

如果你想允許用戶zz從ip為192.168.1.3的主機連接到mysql服務器，並使用123456作為密碼

GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.1.3' IDENTIFIED BY '123456' WITH GRANT OPTION;