主从复制

参考：https://www.cnblogs.com/phpstudy2015-6/p/6485819.html

 

#主数据库

grant replication slave on *.* to user@'%';

show master status;

 

#从数据库

stop slave;
reset salve;

change master to
master_host='host',
master_user='user',
master_password='pass',
master_log_file='mysql-bin.000002',
master_log_pos=123;

start slave;

show slave status\G;

 

 

#从服务器连接主服务器失败

修改用户密码认证方式

alter user slave@'%' identified with mysql_native_password by 'password';

 

转载于:https://www.cnblogs.com/higreen/p/11057256.html