How to install MySQL and MariaDB in Docker

Relationship between MySQL and MariaDB

MariaDB database management system is a branch of MySQL, mainly maintained by the open source community and licensed under the GPL.
MariaDB aims to be fully compatible with MySQL, including API and command line, making it an easy replacement for MySQL.

After reading about the relationship between MySQL and MariaDB, we must be wondering: since the two are so closely related, will there be any conflicts when they are installed and started at the same time?

The answer is yes, for example: `This article mainly explains the port number`. We will first look at the installation of both, and then during the configuration phase, differentiate MariaDB's port number from MySQL.

Install MySQL with Docker

Find the MySQL image on Docker Hub

docker search mysql

Select a mirror to install (here we choose centos/mysql-57-centos7)

docker pull centos/mysql-57-centos7

Start MySQL

docker run -p 3306:3306 --name mysql-57 -v /my/mysql/conf:/etc/mysql/conf.d -v /my/mysql/logs:/logs -v /my/mysql/data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=xxx -d centos/mysql-57-centos7

Install MariaDB with Docker

Find the MariaDB image on Docker Hub

docker search mariadb

Select an image to install (here we choose the official image)

docker pull mariadb

Start MariaDB

docker run -v /my/mariadb/:/var/lib/mariadb -p 3309:3309 -e MYSQL_ROOT_PASSWORD=xxx --privileged=true --restart unless-stopped --name mariadbs -d mariadb:latest

Note: MariaDB starts on port 3309, and MySQL uses the default port 3306.

Startup completed, docker ps view

MariaDB port configuration

Although MariaDB starts using port 3309, we cannot access it remotely.

Enter the container directory

docker exec -it container id bash

Update the configuration file

vi /etc/mysql/my.cnf 

Restart

docker restart container id

Remotely connect and access again, normal!

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.