Local MariaDB Database, using Docker June 3, 2020
Installation
Run the following docker command:
docker run --name mariaDb -e MYSQL_ROOT_PASSWORD=root -d -p 3306:3306 -v mariaDbData:/var/lib/mysql mariadb
Where:
--name
will name the containermariaDb
-p
will expose port3306
to the host machine-v
will create a volume namedmariaDbData
, so the database data will persist between uses
For more information, read docker run --help
Usage
The Docker container running the database can be used the same way as any other instance of a MySQL/MariaDB database. This means you can connect to it using PHPMyAdmin or any other database access tool, such as DBeaver.
MariaDB connection strings are formatted like so: jdbc:mariadb://<host>:<port>/<database>
. The driver's class name is org.mariadb.jdbc.Driver
. The table below contains the default connection information.
Parameter | Value |
---|---|
Connection string | jdbc:mariadb://localhost:3306/<database> |
Host | localhost |
Port | 3306 |
Database | You must create one |
User | root |
Password | root |
Maintenance
Connecting using mysql
To connect using mysql, simply run the following docker command:
> docker exec -ti mariaDb mysql -u root -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 14
Server version: 10.4.13-MariaDB-1:10.4.13+maria~bionic mariadb.org binary distribution
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]>...
MariaDB [(none)]>exit
Where:
-ti
allows to type in an interactive shell-u
provides the user using psql-p
indicates that you wish to provide a password (enterroot
when prompted)
For more information, read docker exec --help
Adding a new user and database
To add a new user and database, start by connecting to the container using mysql, then simply run the following commands:
MariaDB [(none)]>CREATE DATABASE <database>;
MariaDB [(none)]>GRANT ALL PRIVILEGES ON <database>.* TO '<user>'@'%' IDENTIFIED BY '<password>';
Tailing the logs
To tail the logs, simply run the following docker command:
docker logs -f mariaDb --tail 500
Where:
-f
will keep following the logs in real time--tail
will show the last 500 lines of log
For more information, read docker logs --help
Docker Cheatsheet
Last updated on June 3, 2020
— Etienne Lamoureux