Shulou(Shulou.com)06/01 Report--

The MySQL master and slave just configured, which can be seen on the slave computer.

Click (here) to collapse or open

Mysql > SHOW slave STATUS\\ G

* * 1. Row *

Slave_IO_State: Connecting to master

Master_Host: 172.17.210.199

Master_User: my

Master_Port: 3306

Connect_Retry: 60

Master_Log_File: masters-bin.000003

Read_Master_Log_Pos: 1224

Relay_Log_File: testmysql-relay-bin.000001

Relay_Log_Pos: 4

Relay_Master_Log_File: masters-bin.000003

Slave_IO_Running: Connecting

Slave_SQL_Running: Yes

Replicate_Do_DB:

Replicate_Ignore_DB: look at the log, there are many:

Click (here) to collapse or open

141010 0:02:48 [ERROR] Slave Iamp O: error connecting to master\ 'my@172.17.210.199:3306\'-retry-time: 60 retries: 1, Error_code: 2003

141010 0:03:48 [ERROR] Slave Iamp O: error connecting to master\ 'my@172.17.210.199:3306\'-retry-time: 60 retries: 2, Error_code: 2003

141010 0:04:48 [ERROR] Slave Iamp O: error connecting to master\ 'my@172.17.210.199:3306\'-retry-time: 60 retries: 3, Error_code: 2003

141010 0:05:48 [ERROR] Slave Iamp O: error connecting to master\ 'my@172.17.210.199:3306\'-retry-time: 60 retries: 4, Error_code: 2003

141010 0:06:48 [ERROR] Slave Iamp O: error connecting to master\ 'my@172.17.210.199:3306\'-retry-time: 60 retries: 5, Error_code: 2003

141010 0:07:48 [ERROR] Slave my@172.17.210.199:3306 O: error connecting to master\ 'my@172.17.210.199:3306\'-retry-time: 60 retries: 6, Error_code: 2003 solution: there are three main reasons why lave_IO_Running is connecting: 1, the network is not accessible 2, the password is incorrect 3, the pos is incorrect resolution steps: 1, for the first problem, in general, it can be excluded, but also the easiest to eliminate. 2. Change the password of the user used for replication on the main library. 3. When doing chang to, pay attention to whether the log_pos is the same as the host at this time. Show master status\ G on the host; you can see

Mysql > show master status\ G

* * 1. Row *

File: masters-bin.000003

Position: 2392

Binlog_Do_DB:

Binlog_Ignore_DB:

Executed_Gtid_Set:

1 row in set (0.00 sec)

ERROR:

No query specified

Execute the correct change to from the machine

CHANGE MASTER TO

MASTER_HOST='172.17.210.199'

MASTER_USER='my'

MASTER_PASSWORD='123456'

MASTER_LOG_FILE='masters-bin.000003'

MASTER_LOG_POS= 2392

My problem is that the firewall of the host is not turned off and made a low-level mistake!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.