MySQL 2003 (113)

1. Description of the problem

The following error occurred while accessing the MySQL database for the 192.168.2.200 host remotely:

[Plain] View plain copy # Mysql-host192.168.2.200-uroot-p Enter password:error 2003 (HY000): Can ' t connect to MySQL Server on ' 192.168.2.200 ' (113)

2. Workaround

First make sure that MySQL is enabled for remote authorization: http://blog.csdn.net/cryhelyxx/article/details/40114695

Referenced by: http://blog.csdn.net/qustdjx/article/details/26937325

Still can not solve the problem, and finally search the Internet, said the system is the firewall to open the cause.

Reference: 1. View profile: Skip-networking #注释掉 because it's blocking everything. TCP/IP Connection bind-address = 127.0.0.1 #它和上一个选项是异曲同工, if you want to connect remotely, you have to comment out 2. If the above work has been done or appears: Error 2003 (HY000): Can ' t connect to the MySQL server on ' *.*.*.* ' (113), then you have to consider the firewall problem, turn off the firewall/etc/rc.d/init.d/ip Tables stop modified after the restart MySQL (/etc/init.d/mysql restart) to get a workaround.

Now turn off the firewall:

[Plain] View plain copy #/etc/rc.d/init.d/iptables stop iptables:setting chains to policy Accept:filter [OK                               ] iptables:flushing firewall rules: [OK] iptables:unloading modules: [OK]

Connect the MySQL database remotely again:

[plain] view plain copy # mysql -h192.168.2.200 -uroot -p   Enter password:   welcome to the mysql monitor.  commands  end with ; or \g.  Your MySQL connection id is  2962  server 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 its  affiliates. other  names may be trademarks of their respective  owners.     Type  ' help; '  or  ' \h '  for help. Type  ' \c '  to clear the current input  stAtement.    mysql> 

OK, problem solving, Enjoy it!!!

This article is from the "lake and Laughter" blog, please make sure to keep this source http://hashlinux.blog.51cto.com/9647696/1792579

MySQL 2003 (113)