sudo mkdir -p /data/docker/mysql-8.0/etc
sudo mkdir -p /data/docker/mysql-8.0/var
docker run --detach \
--restart always \
--publish 23306 :3306 \
--name mysql-8.0 \
--volume /usr/share/zoneinfo/Asia/Shanghai:/etc/localtime \
--env MYSQL_ROOT_PASSWORD = Gah6kuP7ohfio4 \
mysql:8.0.23
sudo docker cp mysql-8.0:/etc/mysql/conf.d /data/docker/mysql-8.0/etc/conf.d
docker stop mysql-8.0
docker rm mysql-8.0
docker run --detach \
--restart always \
--publish 23306 :3306 \
--name mysql-8.0 \
--volume /data/docker/mysql-8.0/var:/var/lib/mysql \
--volume /data/docker/mysql-8.0/etc/conf.d:/etc/mysql/conf.d \
--volume /usr/share/zoneinfo/Asia/Shanghai:/etc/localtime \
--env MYSQL_ROOT_PASSWORD = Gah6kuP7ohfio4 \
mysql:8.0.23
lwk@qwfys:~$ docker ps -a
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
1647d61060aa mysql:8.0.23 "docker-entrypoint.s…" 31 minutes ago Up 31 minutes 33060 /tcp, 0.0 .0.0:23306-> 3306 /tcp, :::23306-> 3306 /tcp mysql-8.0
lwk@qwfys:~$
spring :
datasource :
hikari :
jdbc-url : jdbc: mysql: //127.0.01: 23306/mysql? useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&serverTimezone=Asia/Shanghai
username : root
password : Gah6kuP7ohfio4
docker stop mysql-8.0
docker rm mysql-8.0