Mysql 同步

CREATE USER 'transer'@'192.168.1.%' IDENTIFIED BY PASSWORD '*CABAB87F17629526560326FA1DC056F77373193F';

 

GRANT FILE , SUPER , REPLICATION SLAVE , REPLICATION CLIENT ON * . * TO 'transer'@'192.168.1.%' IDENTIFIED BY PASSWORD '*CABAB87F17629526560326FA1DC056F77373193F' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;

 

GRANT ALL PRIVILEGES ON `transer\_%` . * TO 'transer'@'192.168.1.%';

 

 

>FLUSH TABLES WITH READ LOCK;
>UNLOCK TABLES

CHANGE MASTER TO MASTER_HOST='192.168.1.218',MASTER_USER='transer',MASTER_PASSWORD='transer_qy2526168',MASTER_LOG_FILE='mysqlm-bin.000001',MASTER_LOG_POS=6137;

 

 

>FLUSH TABLES WITH READ LOCK;
>UNLOCK TABLES

 

CHANGE MASTER TO MASTER_HOST='192.168.1.xxx',MASTER_USER='transer',MASTER_PASSWORD='passwords',MASTER_LOG_FILE='mysqlm-bin.000001',MASTER_LOG_POS=6137;

 

 

改变同步IP:::
GRANT FILE,REPLICATION SLAVE,REPLICATION CLIENT,SUPER ON *.* TO 'tran'@'219.129.239.%' IDENTIFIED BY 'qy2555000';
然后停掉从库，修改IP,再开起来。OK
或者试试，改变指定参数项：CHANGE MASTER TO  MASTER_HOST='192.168.0.116';