In this article, we will have explained the necessary steps to install and configure MariaDB on CentOS 7. Before continuing with this tutorial, make sure you are logged in as a user with sudo privileges. All the commands in this tutorial should be run as a non-root user.
MariaDB is a free and open source fork of well known MySQL database management server software, developed by the brains behind MySQL, it’s envisioned to remain free/open source.
Install MariaDB on CentOS
Step 1. The first command will update the package lists to ensure you get the latest version and dependencies.
sudo yum install epel-release sudo yum update
Step 2. Install MariaDB 10 on CentOS.
First, create a new file /etc/yum.repos.d/MariaDB.repo to enable MariaDB 10 repository on CentOS using following command:
sudo nano /etc/yum.repos.d/MariaDB.repo
Now add the following lines:
[mariadb] name = MariaDB baseurl = http://yum.mariadb.org/10.3/centos7-amd64 gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB gpgcheck=1
Next, Install MariaDB 10.4 using yum package manager:
sudo yum install MariaDB-server MariaDB-client
After installing MariaDB in your system start it’s service using the following command:
sudo systemctl start mariadb sudo systemctl enable mariadb
Step 3. Secure the installation of MariaDB.
After installation, we have to improve MariaDB security by typing following:
sudo mysql_secure_installation
Then enter yes/y to the following security questions:
Remove anonymous users? (Press y|Y for Yes, any other key for No) : y Disallow root login remotely? (Press y|Y for Yes, any other key for No) : y Remove test database and access to it? (Press y|Y for Yes, any other key for No) : y Reload privilege tables now? (Press y|Y for Yes, any other key for No) : y
As a test, you can log into the MySQL server and run the version command:
sudo mysqladmin -p -u root version
Congratulation, you have learned how to install and configure MariaDB on CentOS 7. If you have any question, please leave a comment below.