1.查看配置文件:
skip-networking #注释掉 因为它是屏蔽掉一切TCP/IP连接
bind-address = 127.0.0.1 #它和上一个选项是异曲同工，要想远程连接，也得注释掉
2.如果以上工作都做过还是出现：
ERROR 2003 (HY000): Can't connect to MySQL server on '*.*.*.*' (113)，那就得考虑防火墙的问题了，关掉防火墙/etc/rc.d/init.d/iptables stop
修改完后需要 restart mysql (/etc/init.d/mysql restart)
相关文章
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
- MySQL8.0报错Can't connect to MySQL server on 'localhost' (10061)的解决办法
- 连接数据报错ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
- 连接mysql数据库时提示2003 can't connect to MySQL server on ip(10060)的解决办法
- 远程连接MySQL数据库报错：is not allowed to connect to this MYSQL server的解决办法
- oracle Can't connect to X11 window server using ':0.0' /Checking monitor: must be configured to display at least 256 colors解决方法
- [转]Python UnicodeEncodeError: ‘ascii’ codec can’t encode characters in position 的解决办法
- pip install 安装出现问题：UnicodeEncodeError: 'ascii' codec can't encode characters in position XX的解决办法
- message from server: \"Host is not allowed to connect to this MySQL server\"解决办法
- 解决mysql登陆时出现“ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)”