【笔记】在虚拟中的主从数据库连接实体数据库成功后的从数据库不同步问题解决方法1

130是主数据库 131是从数据数据可以说是一点没同步

解决方法; 重新设置主从连接

在虚拟机中mysql账号xiaoming（主从数据库的桥梁账号）登录

主数据要做的：

show master status；

可以发现这两个值发送了变化

从数据库mysql中登录xiaoming账号：

show slave status；

然后就可以发现它说你的数据过大但是我都没干什么怎么会报这个错

以及我们的从数据库IO流是NO

Slave_IO_State: Master_Host: 192.168.81.130 Master_User: xiaoming Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000010 Read_Master_Log_Pos: 2886 Relay_Log_File: localhost-relay-bin.000006 Relay_Log_Pos: 326 Relay_Master_Log_File: mysql-bin.000010 Slave_IO_Running: No Slave_SQL_Running: Yes Replicate_Do_DB: Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 2886 Relay_Log_Space: 709 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: No Master_SSL_CA_File: Master_SSL_CA_Path: Master_SSL_Cert: Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: NULL Master_SSL_Verify_Server_Cert: No Last_IO_Errno: 13114 Last_IO_Error: Got fatal error 1236 from source when reading data from binary log: 'log event entry exceeded max_allowed_packet; Increase max_allowed_packet on source; the first event 'mysql-bin.000010' at 2886, the last event read from './mysql-bin.000010' at 126, the last byte read from './mysql-bin.000010' at 2905.'

再输入一次change语句

STOP SLAVE;
CHANGE MASTER TO
MASTER_HOST='192.168.81.130',
MASTER_USER='xiaoming',
MASTER_PASSWORD='Shelena27-E',
MASTER_LOG_FILE='mysql-bin.000014',
MASTER_LOG_POS=157;
START SLAVE;

解决了