Docker安装Mysql服务

1. 拉取官方镜像

# docker pull mysql # docker inspect mysql | grep ''VERSION'' "GOSU_VERSION=1.7", "MYSQL_VERSION=8.0.11-1debian9" "GOSU_VERSION=1.7", "MYSQL_VERSION=8.0.11-1debian9" 

1. 运行容器

# docker run -it -d -p 13306:3306 --name db_mysql --restart=always -e MYSQL_ROOT_PASSWORD=root -v /opt/docker/mysql/log:/var/log/mysql -v /opt/docker/mysql/data:/var/lib/mysql -v /opt/docker/mysql/conf:/etc/mysql/conf.d mysql 

1. 查看容器日志

'查看最后200条日志' # docker logs --tail=200 db_mysql '滚动监听' # docker logs -f db_mysql 

1. 配置Mysql

# docker exec -it db_mysql sh # mysql --version mysql Ver 8.0.11 for Linux on x86_64 (MySQL Community Server - GPL) # mysql -uroot -proot mysql> ALTER USER 'root'@'%' IDENTIFIED BY 'root' PASSWORD EXPIRE NEVER; mysql> ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'root'; mysql> ALTER USER 'root'@'%' identified by 'your_passwd'; mysql> FLUSH PRIVILEGES; 

1. 远程连接测试

mysql -h SEREVR_IP -P 13306 -uroot -p