Docker快速安装Mysql 5.6

 #创建mysql专用文件目录

sudo mkdir -p /app/mysql56
sudo mkdir -p /app/mysql56/mysql-conf
sudo mkdir -p /app/mysql56/mysql-files

sudo chmod -R 777 /app/mysql56

 #快速生成配置文件

sudo cat > /app/mysql56/mysql-conf/mysql.conf <<EOF
[client]
#password=123456
[mysqld]

#skip-host-cache
#skip-name-resolve

max_connections = 10000
#innodb_buffer_pool_size = 1G

character_set_server = utf8mb4
collation_server = utf8mb4_unicode_ci
default-time_zone = '+8:00'

pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
datadir = /var/lib/mysql
#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
EOF

#安装mysql

docker run -d \
-v /app/mysql56:/var/lib/mysql \
-v /app/mysql56/mysql-conf:/etc/mysql/mysql.conf.d \
-v /app/mysql56/mysql-files:/var/lib/mysql-files \
-p 8306:3306 \
--restart=always \
--env MYSQL_ROOT_PASSWORD=123456 \
--name mysql \
mysql:5.6