首页 > 数据库技术 > 详细

远程连接MySQL报错ERROR 2003解决办法

时间:2018-06-02 10:16:56      阅读:206      评论:0      收藏:0      [点我收藏+]

转自https://blog.csdn.net/hjwang1/article/details/51669223

问题代码代码

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

远程连接MySQL报错ERROR 2003解决办法

原文:https://www.cnblogs.com/lijurui/p/9124529.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!