docker安装Mysql数据库

安装Mysql数据库

docker run -p 3306:3306 --name mysql5.7 --privileged=true \
-v /usr/local/docker/mysql/conf:/etc/mysql \
-v /usr/local/docker/mysql/logs:/var/log/mysql \
-v /usr/local/docker/mysql/data:/var/lib/mysql \
-e MYSQL_ROOT_PASSWORD=qaz123.0 \
-d mysql:5.7 

docker run -p 3306:3306 --name=mysql8 --privileged=true \
-v /mysql/data:/var/lib/mysql \
-v /mysql/log:/var/log/mysql \
-v /mysql/conf:/etc/mysql/conf.d \
-e MYSQL_ROOT_PASSWORD=qaz123.0 \
-d mysql:8.0

查看容器

docker ps -a 

进入容器

docker exec -it 容器id /bin/bash

登录mysql

mysql -uroot -pqaz123.0

添加远程权限

grant all privileges on *.* to root@'%' identified by 'qaz123.0';
flush privileges;