Mysql主从配置

初始化
mysqld --initialize-insecure --user=mysql --explicit_defaults_for_timestamp
密码修改
use mysql;

//密码为123456
update user set authentication_string=PASSWORD("123456") where user="root";

//更新权限
flush privileges; 
//退出mysql
quit;

服务安装
mysqld --install mysql-3308

主从配置

主：
log-bin=mysql-bin

server-id=1

grant replication slave on *.* to 'rep'@'192.168.108.%' identified by '123456';

从

server-id=2

 CHANGE MASTER TO

-> MASTER_HOST='192.168.108.100',
-> MASTER_PORT=3306,
-> MASTER_USER='rep',

-> MASTER_PASSWORD='123456',

-> MASTER_LOG_FILE='mysql-bin.000002',

-> MASTER_LOG_POS=154