docker安装mysql5.7，挂载配置文件

docker pull mysql:5.7

拉取镜像成功后，可以查看

docker images

 在自己对应的文件夹下新建 conf，data，log三个文件夹

conf下新建：

[mysqld]
user=mysql
character-set-server=utf8
default_authentication_plugin=mysql_native_password
secure_file_priv=/var/lib/mysql
expire_logs_days=7
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
max_connections=1000
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8

windows下my.cnf

docker run --name mysql -p 3306:3306 -v D:/z-office/docker/mysql/conf/my.cnf:/etc/mysql/my.cnf -v D:/z-office/docker/mysql/data:/var/lib/mysql -v D:/z-office/docker/mysql/log:/var/log/mysql -e MYSQL_ROOT_PASSWORD=123456--restart=always -d mysql:5.7

linux下 

docker run --name mysql -p 3306:3306 -v /home/mysql/conf/my.cnf:/etc/mysql/my.cnf -v /home/mysql/data:/var/lib/mysql -v /home/mysql/log:/var/log/mysql -e MYSQL_ROOT_PASSWORD=123456 --restart=always -d mysql:5.7

 更换为自己的文件路径。

连接docker容器中出现ERROR 1045 (28000): Access denied for user ‘root‘@‘localhost‘ (using password: YES)

解决

连接docker容器中出现ERROR 1045 (28000): Access denied for user ‘root‘@‘localhost‘ (using password: YES)_No Big Deal的博客-CSDN博客