下载镜像

docker pull mysql

运行容器

mkdir -p /data/mysql/conf/conf.d
docker run -dit --restart=always --net=host -v /data/mysql/conf:/etc/mysql -v /data/mysql/logs:/var/log/mysql -v /data/mysql/data:/var/lib/mysql --name mysql -e MYSQL_ROOT_PASSWORD=Abc123456 mysql

修改密码

docker exec -it mysql bash
mysql -u root -p
ALTER USER 'root'@'localhost' IDENTIFIED BY 'Abc123456';

开启远程登录

CREATE USER 'liaozesong'@'%' IDENTIFIED WITH mysql_native_password BY 'Lzslov123!';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';

创建用户

CREATE USER 'test'@'%' IDENTIFIED WITH mysql_native_password BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'test'@'%';