使用 docker 部署很方便,但需要注意中文编码格式
文件夹和配置文件
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38
| #!/bin/bash
LOCATION=/root/docker_work/mysql NAME=xxx_mysql PASSWORD=654321 VERSION=5.7 PORT=3307
mkdir -p ${LOCATION}/conf ${LOCATION}/log ${LOCATION}/data
echo " [client] default-character-set=utf8 [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock init_connect='SET collation_connection = utf8_unicode_ci' init_connect='SET NAMES utf8' character-set-server=utf8 collation-server=utf8_unicode_ci skip-character-set-client-handshake symbolic-links=0 [mysql] default-character-set = utf8 [mysqld_safe] log-error=/var/log/mariadb/mariadb.log pid-file=/var/run/mariadb/mariadb.pid #
#" >> ${LOCATION}/conf/my.cnf
docker rm -f ${NAME} docker run -p ${PORT}:3306 --name ${NAME} \ -v ${LOCATION}/log:/var/log/mysql \ -v ${LOCATION}/data:/var/lib/mysql \ -v ${LOCATION}/conf:/etc/mysql/mysql.conf.d \ -e MYSQL_ROOT_PASSWORD=${PASSWORD} \ -d mysql:${VERSION} --character-set-server=utf8mb4 --collation-server=utf8mb4_unicode_ci
|