# 拉取容器
docker pull mysql:5.7
# 创建容器
docker run -p 3316:3306 --name mysql-5.7 \
-v /wuming/mysql5.7/log:/var/log/mysql \
-v /wuming/mysql5.7/data:/var/lib/mysql \
-v /wuming/mysql5.7/conf:/etc/mysql \
-e MYSQL_ROOT_PASSWORD=root \
-d mysql:5.7
docker update mysql-5.7 --restart=always
docker exec -it mysql-5.7 /bin/bash
登入mysql服务器
mysql -uroot -p
use mysql;
# 修改密码
update user set authentication_string = password('123'), password_expired = 'N', password_last_changed = now() where user = 'root';
# 修改mysql的密码的加密策略
update user set plugin="mysql_native_password";
# 刷新权限
flush privileges;
# 退出
quit;