docker安装MySQL

创建文件夹  
/opt/mysql_3309
切换到/opt/mysql_3309
cd /opt/mysql_3309
查看路劲
echo $PWD

创建数据库
docker run --name mysql_qjjc_3309 -v $PWD/conf:/etc/mysql/conf.d -v $PWD/logs:/logs -v $PWD/data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=qjjc@123 -d -i -p 3309:3306 mysql:5.7

也可以：

docker run -i -t --name=mysq-3306  \
-p 3306:3306   \
-v /data/bakmysql:/var/lib/mysql   \
-v /data/mysqlNew/conf:/etc/mysql   \
-e MYSQL_ROOT_PASSWORD=123456   \
-e "TZ=Asia/Shanghai"  \
--restart=always \
-v /etc/localtime:/etc/localtime \
-d mysql:5.7.38

授权远程连接

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';