Docker搭建Mysql #

docker run -p 13306:3306 --name mysql --restart=always --privileged=true \
-v /usr/local/mysql/conf/my.cnf:/etc/mysql/my.cnf \
-v /usr/local/mysql/logs:/logs  \
-v /usr/local/mysql/data:/var/lib/mysql  \
-v /usr/local/mysql/mysql-files:/var/lib/mysql-files  \
-e TZ=Asia/Shanghai \
-e MYSQL_ROOT_PASSWORD=123456Aa.  -d mysql

[mysql]
default-character-set=utf8
 
[client]
port=3306
default-character-set=utf8
 
[mysqld]
port=3306
server-id=3306
user=mysql
general_log=1
character-set-server=utf8
collation-server=utf8_unicode_ci

# 大小写不敏感
lower_case_table_names=1
autocommit=1
symbolic-links=0
default_authentication_plugin=mysql_native_password