docker搭建mysql主从复制时,mysql8和mysql5有两处不同
1、配置文件的容器卷:
docker run -p 3307:3306 \
--name mysql-master \
--privileged=true \
-v /app/mysql-master/log:/var/log/mysql \
-v /app/mysql-master/data:/var/lib/mysql \
-v /app/mysql-master/conf:/etc/mysql/conf.d \
-v /app/mysql-master/files:/var/lib/mysql-files \
-e MYSQL_ROOT_PASSWORD=123456 \
-d mysql:8.0.16
注意我加粗加红的两句
2、在主机上配置从机账号时的命令应该是:
ALTER USER 'slave'@'%' IDENTIFIED WITH mysql_native_password BY '123456';