Docker快速安装mysql单机

拉取镜像

docker pull mysql:5.7

启动容器

sudo docker run -p 3306:3306 --name mysql \
-v /data/mysql:/etc/mysql \
-v /data/mysql/lib:/var/lib/mysql \
-e MYSQL_ROOT_PASSWORD=zzl123 \
-d mysql:5.7

配置文件

vim /data/mysql/my.cnf

[mysqld]
default-time-zone = '+8:00'
pid-file=/var/run/mysqld/mysqld.pid
socket=/var/run/mysqld/mysqld.sock
log-error = /var/log/mysql/error.log
# By default we only accept connections from localhost
#bind-address  = 127.0.0.1
# Disabling symbolic-links is recommended to prevent assorted security risks
#symbolic-links=0

进入mysql执行sql脚本

docker exec -it mysql /bin/bash

mysql -uroot -pzzl123;

use mysql;

时区修改

set global time_zone = '+8:00';
set time_zone = '+8:00';
flush privileges;