GRANT REPLICATION SLAVE ON *.* TO 'slave_user'@'%' IDENTIFIED BY 'password';
如果授权失败,输入以下命令,添加用户,之后再授权,记得用户名密码要统一
1 2 3 4
mysql> CREATE USER 'monty'@'localhost' IDENTIFIED BY 'some_pass'; mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost' WITH GRANT OPTION; mysql> CREATE USER 'monty'@'%' IDENTIFIED BY 'some_pass'; mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'%' WITH GRANT OPTION;
更新权限
1
FLUSH PRIVILEGES;
表加锁
如果不能保证在配置过程中表不会被修改,建议给表加锁,防止同步出现错误。
加锁
1 2
USE newdatabase; FLUSH TABLES WITH READ LOCK;
记录主库二进制日志文件 记录File名和Positiion位置,从库配置需要用到。
1 2 3 4 5 6 7
mysql> SHOW MASTER STATUS; +------------------+----------+--------------+------------------+ | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | +------------------+----------+--------------+------------------+ | mysql-bin.000001 | 107 | newdatabase | | +------------------+----------+--------------+------------------+ 1 row in set (0.00 sec)