# 重启mysql容器
docker restart mysql
# 设置docker启动时启动mysql
docker update mysql --restart=always
# 重启mysql容器
docker restart mysql
# 进入mysql容器内部
docker exec -it mysql /bin/bash
# 退出mysql容器
exit
远程登录
# 进入容
docker exec -it mysql8.0 bash
# 链接数据库
mysql -uroot -p123456
# 切换数据库节点
use mysql
# 查询数据库用户表关键信息
SELECT Host, User, plugin from user;
# 修改加密规则
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';
# 立即生效配置
FLUSH PRIVILEGES;