mysql主从同步配置

= /data/mysql/mysql_m-bin #开启binlog

2.重启mysql,后生成日志文件

cat /data/mysql/mysql_m-bin.000001 #把里面记录的日志文件名记录下来等一下从库要用到

3.创建用户并授权

mysql -uroot -p
grant replication slave on *.* to "cs-1"@"192.168.199.%"identified by "wangwei"; 
flush privileges;

4.查看主库id和状态

SHOW VARIABLES LIKE ‘server_id‘; #查看id
SET GLOBAL server_id=1;  #修改id，保证主从库id不同

 

mysql主从同步配置

标签：mysql开启   创建   创建用户   root   color   col   class   查看   replica