Run MariaDB on RancherOS

Run with volume:

ver=10.3.17
mkdir -p ${HOME}/mariadb/$ver/conf.d
docker run --name mariadb \
-v ${HOME}/mariadb/$ver/conf.d:/etc/mysql/conf.d \
-e MYSQL_ROOT_PASSWORD="zabbix" \
-p 3307:3306 \
-d mariadb:$ver

Launch utility:

docker exec -it mariadb mysql -uroot -pzabbix

docker exec -it mariadb10317 mysql -uroot -pzabbix Create user:

CREATE USER 'zabbix'@'%' IDENTIFIED BY 'zabbix';
CREATE DATABASE z42 CHARACTER SET utf8 COLLATE utf8_bin;

# all permissions
# GRANT ALL PRIVILEGES ON z42.* TO 'zabbix'@'%';

# bare minimum to function well
GRANT SELECT, UPDATE, DELETE, INSERT, CREATE, DROP, ALTER, INDEX, REFERENCES ON z42.* TO 'zabbix'@'%';

FLUSH PRIVILEGES;
exit

10.4.23:

mkdir -p /home/rancher/mariadb/10.4.13/cnf
docker run --name mariadb10413 \
-v /home/rancher/mariadb/10.4.13/cnf:/etc/mysql/conf.d \
-e MYSQL_ROOT_PASSWORD="zabbix" \
-p 10413:3306 \
-d mariadb:10.4.13