MariaDB is a fork of MySQL server, a popular RDBMS database available for free. Personally, I use MySQL or MariaDB to power up this blog and also I use it to store my spatial datasets. Well, there are many companies that rely their data on MariaDB. I was working on a Gold Exploration company which uses MariaDB server to store our drilling and exploration data. On this article, you will find an easy way to install MariaDB Server on Manjaro 18.0. Manjaro 18.0 is now available for download. It is a great, beautiful and stable Linux operating system.
In most cases, you may want to install MariaDB Server on your system directly. But, there is also a new way to install and run MariaDB Server, by using Docker container. I will explain these two ways to install MariaDB on Manjaro 18.0. Let’s start.
Lesson 1. Install MariaDB Server on Manjaro 18.0 directly
You can get the server up and running by executing this command below on Terminal.
sudo pacman -S mariadb
[dhani@dhani-pc ~]$ sudo pacman -S mariadb [sudo] password for dhani: resolving dependencies... looking for conflicting packages... Packages (4) jemalloc-1:5.1.0-1 libmariadbclient-10.1.35-1 mariadb-clients-10.1.35-1 mariadb-10.1.35-1 Total Download Size: 32,58 MiB Total Installed Size: 230,31 MiB :: Proceed with installation? [Y/n]
After the installation finishes, continue with this command
sudo mysql_install_db --user=mysql --basedir=/usr --datadir=/var/lib/mysql
The command will initialize the Mariadb database for the first time. You can change the value of the datadir option if you don’t want to use the default one. In this example, I use my /var/lib/mysql to store the database.
Next, start the service
sudo systemctl start mariadb sudo systemctl enable mariadb
Next, we need to secure the MariaDB
Follow on screen instructions until it completed. Now your server should be ready.
Install MySQL Workbench 8.0 on Manjaro 18.0
It is optional, but we recommend you to install MySQL Workbench 8.0 on Manjaro. Workbench is an official GUI tool to manage MySQL server.
sudo pacman -S mysql-workbench
In a moment, the Workbench is ready to use
Lesson 2. Install and Run MariaDB Server Container
There is another way to install MariaDB Server on Manjaro Linux. On this lesson, we are going to run MariaDB server container using Docker. If you are new to Docker, you can read about this great piece of technology here. First, you will need to install Docker on Manjaro 18.0. Once you have Docker on your computer, open Terminal and run this command to install MariaDB.
sudo docker run --name mariadb01 -e MYSQL_ROOT_PASSWORD='12345' -p 33060:3306 -d mariadb
- mariadb01 ==> Name of the container. Change it with something you like
- 12345 ==> the root password for Mariadb. You need to change this value with your own password
- 33060 ==> The port that is used by Mariadb. You can change it with other number. Or, leave the default value which is 3306
The command will download the latest mariadb docker image from the internet.
Connect MySQL Workbench with the MariaDB Container
Open Workbench and then click the + symbol to add a new connection.
Give it a new connection name. And then on the hostname, type 0.0.0.0 (if you connect it from the same host). If you connect from other computer, type the ip address of the Docker host. Enter other credentials such as port and password for root. Finally, hit Test Connection and make sure you can connect to it.
That’s it. We have learned how to install MariaDB Server on Manjaro 18.0 directly and via Docker Container. I hope you enjoy this tutorial, please share and see you on the next tutorial.