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.
1 2 | sudoyuminstallepel-release sudoyumupdate |
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:
1 | sudonano/etc/yum.repos.d/MariaDB.repo |
Now add the following lines:
1 2 3 4 5 | [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:
1 | sudoyuminstallMariaDB-serverMariaDB-client |
After installing MariaDB in your system start it’s service using the following command:
1 2 | sudosystemctlstartmariadb sudosystemctlenablemariadb |
Step 3. Secure the installation of MariaDB.
After installation, we have to improve MariaDB security by typing following:
1 | sudomysql_secure_installation |
Then enter yes/y to the following security questions:
1 2 3 4 | Removeanonymoususers?(Pressy|YforYes,anyotherkeyforNo):y Disallowrootloginremotely?(Pressy|YforYes,anyotherkeyforNo):y Removetestdatabaseandaccesstoit?(Pressy|YforYes,anyotherkeyforNo):y Reloadprivilegetablesnow?(Pressy|YforYes,anyotherkeyforNo):y |
As a test, you can log into the MySQL server and run the version command:
1 | sudomysqladmin-p-urootversion |
Congratulation, you have learned how to install and configure MariaDB on CentOS 7. If you have any question, please leave a comment below.
