Docker快速安装Mysql8

 #创建mysql专用文件目录

sudo mkdir -p /app/mysql/mysql-data
sudo mkdir -p /app/mysql/mysql-cnf
sudo mkdir -p /app/mysql/mysql-files
sudo chmod -R 777 /app/mysql

 #快速生成配置文件

sudo cat > /app/mysql/mysql-cnf/mysql.cnf <<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/mysql/mysql-data:/var/lib/mysql \
-v /app/mysql/mysql-cnf:/etc/mysql/conf.d  \
-v /app/mysql/mysql-files:/var/lib/mysql-files \
-p 3306:3306 \
--restart=always \
-e MYSQL_ROOT_PASSWORD=123456 \
-e TZ=Asia/Shanghai \
--name mysql  \
mysql:8