raspberrypi docker mariadb

https://hub.docker.com/r/maurosoft1973/alpine-mariadb/

Docker

 

Volume structure

• /etc/my.cnf.d: MariaDB Configuration file
• /var/lib/mysql: Database files
• /var/lib/mysql/mysql-bin: MariaDB logs

Environment Variables:

Main MariaDB parameters:

• LC_ALL: default locale (en_GB.UTF-8)
• TIMEZONE: default timezone (Europe/Brussels)
• MYSQL_DATA_USER: specify the mysql owner data directory (default mysql)
• MYSQL_DATA_USER_UID: specify the uid for mysql owner data directory (default 100)
• MYSQL_DATA_GROUP: specify the mysql group data directory (default mysql)
• MYSQL_DATA_GROUP_UID: specify the gid for mysql group data directory (default 101)
• MYSQL_DATABASE: specify the name of the database
• MYSQL_CHARSET: default charset (utf8) for Mariadb
• MYSQL_COLLATION: default collation (utf8_general_ci) for Mariadb
• MYSQL_USER: specify the user for the database
• MYSQL_PASSWORD: specify the user password for the database
• MYSQL_ROOT_PASSWORD: specify the root password for Mariadb

 

 

docker pull maurosoft1973/alpine-mariadb

 

create volume vol_db

/var/lib/mysql

create volume vol_db_log

/var/lib/mysql/mysql-bin

 

docker run -d --name mysql -p 3306:3306 --restart always -v vol_db:/var/lib/mysql -v vol_db_log:/var/lib/mysql/mysql-bin -e MYSQL_DATABASE=MORONING -e MYSQL_USER=username -e MYSQL_PASSWORD=password -e MYSQL_ROOT_PASSWORD=passwordRT maurosoft1973/alpine-mariadb --character-set-server=utf8mb4 --collation-server=utf8mb4_unicode_ci