mariadb

拉取镜像

:::info docker pull mariadb:10.7.4-focal :::

创建容器实例

:::info docker run -it -p 18001:3306 -v /home/pande/mariadb-v00/conf/:/etc/mysql/ -v /home/pande/mariadb-v00/data/:/var/lib/mysql/ -v /home/pande/mariadb-v00/log/:/var/log/mysql/ —privileged=true -e MARIADB_USER=mdbu -e MARIADB_PASSWORD=mdbu_pwd -e MARIADB_ROOT_PASSWORD=mdbu_pwd_root —name=mdb00 mariadb:10.7.4-focal :::

配置文件：/etc/mysql/ 数据：/var/lib/mysql/ 日志：/var/log/mysql/

字符集更改

查看字符集情况 :::info show variables like ‘char%’; ::: 更改配置文件 :::info [client]
default-character-set=utf8mb4
[mariadbd]
collation_server=utf8_general_ci
character-set-server=utf8mb4 :::

用户权限设置

:::info grant select, insert, update, delete, create on pfinance.* to ‘mdbu’@’%’;
flush privileges; :::