Image Overview: mariadb
Overview: mariadb Chainguard Image
MariaDB is one of the most popular open source relational databases.
Download this Image
The image is available on cgr.dev
:
docker pull cgr.dev/chainguard/mariadb:latest
Using MariaDb
The default MariaDB port is 3306. To run with Docker and allow empty passwords:
$ docker run -p 3306:3306 --rm -e MARIADB_ALLOW_EMPTY_ROOT_PASSWORD=1 cgr.dev/chainguard/mariadb
Mon Jan 23 03:47:20 UTC 2023 [Note] [Entrypoint]: Entrypoint script for MariaDB Server started.
Mon Jan 23 03:47:20 UTC 2023 [Note] [Entrypoint]: Initializing database files
PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER !
To do so, start the server, then issue the following command:
'/usr/bin/mysql_secure_installation'
which will also give you the option of removing the test
databases and anonymous user created by default. This is
strongly recommended for production servers.
See the MariaDB Knowledgebase at https://mariadb.com/kb
Please report any problems at https://mariadb.org/jira
The latest information about MariaDB is available at https://mariadb.org/.
Consider joining MariaDB's strong and vibrant community:
https://mariadb.org/get-involved/
Mon Jan 23 03:47:21 UTC 2023 [Note] [Entrypoint]: Database files initialized
...
2023-01-23 3:47:23 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-01-23 3:47:23 0 [Note] InnoDB: Buffer pool(s) load completed at 230123 3:47:23
2023-01-23 3:47:23 0 [Note] Server socket created on IP: '0.0.0.0'.
2023-01-23 3:47:23 0 [Note] Server socket created on IP: '::'.
2023-01-23 3:47:23 0 [Note] mariadbd: ready for connections.
Version: '10.6.11-MariaDB' socket: '/run/mysqld/mysqld.sock' port: 3306 MariaDB Server
Users and Directories
By default, this image runs as a non-root user named mysql
with a uid of 65532.
Environment Variables
You can use environment variables to create a new database and user upon initialization, and also to set up the root account password.
MARIADB_ROOT_PASSWORD
: Sets the password for MariaDB’s root superuser account. If this variable is not set, you’ll need to use eitherMARIADB_RANDOM_ROOT_PASSWORD
orMARIADB_ALLOW_EMPTY_ROOT_PASSWORD
in order to initialize the database successfully.MARIADB_RANDOM_ROOT_PASSWORD
: A non-zero value sets up a random password for the root superuser account.MARIADB_ALLOW_EMPTY_ROOT_PASSWORD
: A non-zero value allows for an empty root password.MARIADB_DATABASE
: Creates a new database upon initialization.MARIADB_USER
: Together withMARIADB_PASSOWORD
, this environment variable can be used to create a new database user and grant them full access to the database defined byMARIADB_DATABASE
.MARIADB_PASSWORD
: This should be used in conjunction with theMARIADB_USER
environment variable to set up the database user’s password.
Docker Compose Example
This docker-compose.yaml
sets up a MariaDB database with a default database and user. Other services can be added to create a local multi-node environment for development and tests.
version: "3.7"
services:
mariadb:
image: cgr.dev/chainguard/mariadb
restart: unless-stopped
environment:
MARIADB_RANDOM_ROOT_PASSWORD: yes
MARIADB_USER: user
MARIADB_PASSWORD: password
MARIADB_DATABASE: test
ports:
- 3306:3306
volumes:
- ./:/app
networks:
- wolfi
networks:
wolfi:
driver: bridge
Last updated: 2024-04-11 12:38