docker运行mariadb，并指定字符集utf8

docker命令

docker run -p 3306:3306 --name mariadb -v /mydata/mariadb/mysql:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=root -d mariadb --character-set-server=utf8 --collation-server=utf8_general_ci

修改自启动

 docker container update --restart=always mariadb

mariadb创建用户

create user mariadb@'%' identified by 'mariadb';

mariadb用户授权

grant all privileges on *.* to mariadb@'%' identified by 'mariadb';