can t connect to mysql server on 113

Translated from: http://blog.csdn.net/chengyuqiang/article/details/542858571, the program error :Com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:Communications Link2. Try to connect to the database remotely :[Email protected] ~]# mysql-h192.1

[Email protected] ~]# mysql-uroot-h192.168.56.105-pEnter Password:ERROR 2003 (HY000): Can ' t connect to MySQL server on ' 192.168.56.105 ' (113)Analysis of the problemThese problems may occur in the following ways1. Skip-networking is configured in

1. Description of the problemThe 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

I. Question-making/usr/local/webserver/mysql/bin/mysql-u root-h 172.29.141.112-p-s/tmp/mysql.sockEnter Password:ERROR 2003 (HY000): Can ' t connect to MySQL server on ' 172.29.141.112 ' (113)Two. Analysis of the problemThese problems may occur in

I. Question-making/usr/local/webserver/mysql/bin/mysql-u root-h 172.29.141.112-p-s/tmp/mysql.sockEnter Password:ERROR 2003 (HY000): Can ' t connect to MySQL server on ' 172.29.141.112 ' (113)Two. Analysis of the problemThese problems may occur in

http://blog.csdn.net/longxibendi/article/details/6363934I. Question-making/usr/local/webserver/mysql/bin/mysql-u root-h 172.29.141.112-p-s/tmp/mysql.sockEnter Password:ERROR 2003 (HY000): Can ' t connect to MySQL server on ' 172.29.141.112 '

1. View configuration file: Skip-networking #注释掉 because it's shielding 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

1. Check if you have installed:Yum List installed mysql*Rpm-qa | grep mysql*2. Check that there are no installation packages:Yum List mysql*3. Install the MySQL client:Yum install MySQL4. Install the MySQL server side:Yum Install Mysql-serverYum

Hive version hive-0.11.0Sqoop version sqoop-1.4.4.bin__hadoop-1.0.0From Hive to MySQLMySQL table:mysql> desc cps_activation; + ———— + ————-+--+-–+ ——— + —————-+| Field | Type | Null | Key | Default | Extra |+ ———— + ————-+--+-–+ ——— + —————-+| ID |

MySQL cluster architecture in many ways, according to different needs to do the same architecture, the simple point is the MySQL replication, that is, MySQL replication function, the mode is: Master-slaves,master-slaves-slaves, Master-master-slaves