mysql主从配置说明 Slave_SQL_Running: No 的原因解决

mysql主从配置说明 Slave_SQL_Running: No 的原因解决
Slave_SQL_Running: No 的原因解决

主服务器 show master status\G
查询到master_log_file=‘mysql-bin.000006’ 和master_log_pos=425487;

在从服务器 change master to master

grant replication slave,reload,super on . to slave@123.1.151.58 identified by ‘root’;

mysql -u slave -p root -h 118.184.29.231

mysql> grant replication slave,replication client on . -> to q974350000@‘118.184.29.231’ identified by ‘123456’;

mysql> change master to master_host=‘123.1.151.58’, -> master_user=‘q974350000’, -> master_password=‘123456’, -> master_log_file=‘mysql-bin.000001’, -> master_log_pos=0;

REPAIR TABLE user;

myisamchk -f ‘e:\556\phpstudy\MySQL\data\mysql*.MYI’;

show slave status\g;
show master status\g;

show slave status\G

show master status\G

118.184.29.231

start slave;

<