主库ip 216.83.54.83
从库ip 1216.83.54.84
数据库备份
mysqldump -uroot -p --databases xhjgame>xhjgame.sql主库
>CREATE USER 'slave'@'216.83.54.84' IDENTIFIED BY '密码';
>GRANT REPLICATION SLAVE ON *.* TO 'slave'@'216.83.54.84';
>flush privileges;
> show master status从库 注意两个值 mysql-bin.00058 和MASTER_LOG_POS
>CHANGE MASTER TO MASTER_HOST='216.83.54.83',
MASTER_USER='slave',
MASTER_PASSWORD='密码',
MASTER_LOG_FILE='mysql-bin.000587', MASTER_LOG_POS=0;
>start slave
>show slave status
