docker 安装mysql容器

• docker创建mysql容器

docker run -p 3307:3306 --name mysql-container -v /www/mysql/slave/log:/var/log/mysql -v /www/mysql/slave/data:/var/lib/mysql -v /www/mysql/slave/config/my.cnf:/etc/my.cnf -e MYSQL_ROOT_PASSWORD=123456 -e identified=mysql_native_password -d mysql:8.0.24

• 进入docker 容器

docker exec -it mysql-container

• 修改mysql远程连接权限

use mysql;
update user set host='%' where user='root' ;

grant all privileges on *.* to 'root'@'%' ;

flush privileges ;

select host from user where user='root';

alter user 'root'@'%' identified with mysql_native_password by '123456';

select host, user, authentication_string, plugin from user

下面为主从配置相关命令，记录用，不完整

• 创建用户，并赋权限

create user 'slave21'@'%' identified with mysql_native_password by '1qaz@WSX3edc';

grant replication slave on *.* to 'slave21'@'%';

flush privileges;

show grants for 'slave21'@'%';

• 进入容器，执行主从同步命令

docker exec -it mysql-container mysql -u root -p

change master to master_host='172.17.0.1',master_user='slave21',master_password='1qaz@WSX3edc',master_log_file='mysql-bin.000022',master_log_pos=2900;

stop slave;

start slave;

show slave status \G