安装mysql

创建挂载目录

mkdir /data/mysql/log
mkdir /data/mysql/data
mkdir /data/mysql/conf

创建并启动容器

docker run --restart=always --privileged=true -p 3306:3306 --name mysql -v /data/mysql/log:/var/log/mysql -v /data/mysql/data:/var/lib/mysql -v /data/mysql/conf:/etc/mysql/conf -e MYSQL_ROOT_PASSWORD=zroot123 -d mysql:8.0

进入容器

docker exec -it mysql bash

登录mysql

mysql -u root -p zroot123

修改密码

UPDATE mysql.user SET authentication_string='' WHERE user='root' and host='localhost';

修改密码为永不过期

ALTER USER 'root'@'%' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER; 

刷新

flush privileges;

授权远程连接

alter user 'root'@'%' IDENTIFIED BY '你的密码';```
刷新

flush privileges;