centos6下解决"ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.2.200' (113)"
来源:互联网 发布:excel从网页导入数据 编辑:程序博客网 时间:2024/06/14 02:35
1. 问题描述
远程访问192.168.2.200主机的mysql数据库时, 出现以下错误:
# mysql -host192.168.2.200 -uroot -pEnter password: ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.2.200' (113)
2. 解决方法
首先确保mysql开启了远程授权: http://blog.csdn.net/cryhelyxx/article/details/40114695
参考了: http://blog.csdn.net/qustdjx/article/details/26937325
依然无法解决问题, 最后在网上搜索了下, 说是系统的防火墙开启的原因.
参考了: http://www.jb51.net/article/23965.htm 得到了解决方法.
现在关闭防火墙:
# /etc/rc.d/init.d/iptables stopiptables: Setting chains to policy ACCEPT: filter [ OK ]iptables: Flushing firewall rules: [ OK ]iptables: Unloading modules: [ OK ]
再次远程连接mysql数据库:
# mysql -h192.168.2.200 -uroot -pEnter password: Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 2962Server version: 5.5.22-log MySQL Community Server (GPL)Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql>
OK, 问题解决, Enjoy it!!!
0 0
- centos6下解决"ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.2.200' (113)"
- 解决"ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.247.128' (111)"
- 【解决】ERROR 2003 (HY000): Can't connect to MySQL server on "host" (113)
- ERROR 2003 (HY000): Can't connect to MySQL server on
- ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.56.105' (113)
- ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.1.165' (113)
- ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.1.165' (113)
- mysql 解决 ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
- MySQL错误ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)的解决
- 解决ERROR 2003 (HY000): Can't connect to MySQL server on "host" (111)
- 解决ERROR 2003 (HY000): Can't connect to MySQL server on "host" (111)
- 解决 error 2003 (hy000): can't connect to mysql server on 'localhost' (10061)
- ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.0.114' (111)
- ERROR 2003 (HY000): Can’t connect to MySQL server on ’192.168.119.105′ (10061)
- ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.0.123' (10061)
- ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.10.210' (111) 解决方法
- ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.1.157' (111)
- 【linux错误解决】MySQL远程连接ERROR 2003 (HY000):Can't connect to MySQL server on'XXXXX'的问题
- USB Mass Storage大容量存储的基本知识
- C语言及程序设计初步例程-32 输出小星星
- uiwebview didFailLoadWithError -999 error code
- Android特色开发之账户管理
- 数据库定义规范(可以借鉴,不是硬性标准)
- centos6下解决"ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.2.200' (113)"
- android 多线程2:thread
- MongoDB数据文件内部结构
- iOS中的多任务: Background Fetch,Silent Remote Notifications,Background Transfer Service
- C语言及程序设计初步例程-33 三种循环语句
- Android获取SDK版本号 判断版本号
- JS中setTimeout()的用法详解
- Android Tips:CursorAdapter 绑定 ListView后,List滚动CheckBox选中消失的问题
- 数据结构——二叉树