Can't connect to MySQL server的解決辦法
1.查看配置文件:
skip-networking #注釋掉 因?yàn)樗瞧帘蔚粢磺蠺CP/IP連接
bind-address = 127.0.0.1 #它和上一個(gè)選項(xiàng)是異曲同工,要想遠(yuǎn)程連接,也得注釋掉
2.如果以上工作都做過還是出現(xiàn):
ERROR 2003 (HY000): Can't connect to MySQL server on '*.*.*.*' (113),那就得考慮防火墻的問題了,關(guān)掉防火墻/etc/rc.d/init.d/iptables stop
修改完后需要 restart mysql (/etc/init.d/mysql restart)
