MariaDB is a database system that is a MySQL branch and uses MariaDB Storage Engine as a storage engine. At the beginning of the database’s entry into the market, experts and programmers did not welcome it, believing that it did not have the power to compete with MySQL.
But it did not take long for programmers to use the database and find out because of the base’s core MariaDB Data, which is similar to MySQL, and programs run smoothly with this database.
In the following, we will check how to install MariaDB in Debian 9 and make it online to be functional.
Steps To Install MariaDB
1. First, connect to your Debian 9 terminal through SSH (How To Connect To Linux VPS Through Putty?)
2. Then enter the following command to update the list of your Debian repository.
3. After completing the previous command steps, enter the following command to download and install the latest version of MariaDB on your Debian 9.
apt install mariadb-server
4. After downloading and installing MariaDB, enter the following command to make this service’s default settings.
After entering the above command, you will first be asked to enter a password for your database Root user or not? By pressing the Enter key, the none option is selected by you, and the system will ask you for a password twice to assign to the root user of the MariaDB database.
Enter the password and complete all the steps.
How To Work With MariaDB Service On Debian 9
The MariaDB database service, like other services installed on Debian, uses Systemd, and you can manage it with the systemctl command.
Start MariaDB on Debian 9
systemctl start mariadb
Stop MariaDB on Debian9
systemctl stop mariadb
Enable MariaDB service in Debian 9 startup
systemctl enable mariadb
Disable MariaDB service in Debian 9 startup
systemctl disable mariadb
Show the status of MariaDB Service.
systemctl status mariadb
This will allow you to install and manage MariaDB on your Debian Linux VPS.
We hope you enjoy the tutorial on installing MariaDB in Debian 9 at the end.