docker mysql-8.0.27

[client]
default-character-set=utf8

[mysqld]
datadir=/var/lib/mysql/data
socket=/var/lib/mysql/mysql.sock
pid-file= /var/lib/mysqld/mysqld.pid 
init_connect='SET collation_connection = utf8_unicode_ci'
init_connect='SET NAMES utf8'
character-set-server=utf8mb4
collation-server=utf8mb4_general_ci
skip-character-set-client-handshake
default-storage-engine=INNODB
lower_case_table_names=0
symbolic-links=0

[mysql]
default-character-set = utf8

[mysqld_safe]
log-error=/var/log/mariadb/mariadb.log
pid-file=/var/run/mariadb/mariadb.pid

#
# include all files from the config directory
#
!includedir /etc/my.cnf.d

docker run -d --restart=always --name hite-mysql \
--privileged=true \
-v /var/lib/mysql/conf:/etc/mysql/conf.d \
-v /var/lib/mysql/data:/var/lib/mysql \
-v /var/lib/mysql/logs:/var/log/mysql \
-p 3306:3306 \
-e TZ=Asia/Shanghai \
-e MYSQL_ROOT_PASSWORD=xin123456 \
mysql:8.0.27 \
--character-set-server=utf8mb4 \
--collation-server=utf8mb4_general_ci