This guide will quickly take you through how to install MariaDB 10.3 on CentOS 7. The current stable release of MariaDB is v10.3.15. Se how to install MariaDB 10.3 on Fedora 30 by following the link below;
Install MariaDB 10.3 on CentOS 7
Update and upgrade your system packages.
yum update yum upgrade
Adding the MariaDB YUM repository
The latest stable version of MariaDB is not available on the default CentOS 7 repositories. Hence you need to add the YUM repository so as to install the latest version of MariaDB
cat > /etc/yum.repos.d/mariadb.10.3.repo << EOF [mariadb] name = MariaDB baseurl = http://yum.mariadb.org/10.3/centos7-amd64 gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB gpgcheck=1 EOF
Next, run the system update again to resynchronize packages to their latest versions.
yum update -y
Install MariaDB 10.3 on CentOS 7
Once you have the MariaDB repos in place, proceed to do the installation of both MariaDB server and client by executing the commands below;
yum install mariadb mariadb-server
... =========================================================================== Package Arch Version Repository Size =========================================================================== Installing: MariaDB-client x86_64 10.3.15-1.el7.centos mariadb 11 M MariaDB-server x86_64 10.3.15-1.el7.centos mariadb 24 M ...
Running MariaDB on CentOS 7
Once the installation is done, you can start and enable MariaDB to run on system boot by executing the commands below;
systemctl start mariadb systemctl enable mariadb
Set MariaDB Root Password
To set the MariaDB root password, run the command below. Replace new-password with your password.
mysqladmin -u root password 'new-password'
The password can also be set using the MariaDB security script.
Initial MariaDB Security
MariaDB ships with a simple MariaDB security script, mysql_secure_installation, that basically enables you to remove test databases and anonymous user created by default. This is strongly recommended for production servers. This script can be simply run as;
The first prompt would be to set the root password. however, if you have set it above, just enter the password and proceed.
... In order to log into MariaDB to secure it, we'll need the current password for the root user. If you've just installed MariaDB, and you haven't set the root password yet, the password will be blank, so you should just press enter here. Enter current password for root (enter for none): OK, successfully used password, moving on... Setting the root password ensures that nobody can log into the MariaDB root user without the proper authorisation. You already have a root password set, so you can safely answer 'n'. Change the root password? [Y/n] n
Next, remove the database anonymous user.
By default, a MariaDB installation has an anonymous user, allowing anyone to log into MariaDB without having to have a user account created for them. This is intended only for testing, and to make the installation go a bit smoother. You should remove them before moving into a production environment. Remove anonymous users? [Y/n] y ... Success!
Disable remote root login
Normally, root should only be allowed to connect from 'localhost'. This ensures that someone cannot guess at the root password from the network. Disallow root login remotely? [Y/n] ... Success!
Remove test databases
By default, MariaDB comes with a database named 'test' that anyone can access. This is also intended only for testing, and should be removed before moving into a production environment. Remove test database and access to it? [Y/n] y - Dropping test database... ... Success! - Removing privileges on test database... ... Success!
Reload the privileges tables to effect the changes.
Reloading the privilege tables will ensure that all changes made so far will take effect immediately. Reload privilege tables now? [Y/n] y ... Success!
That is all about the installation MariaDB 10.3.
To verify that you MariaDB is working fine, login and run some test queries. For example to check the version;
mysql -u root -p
MariaDB [(none)]> select version(); +-----------------+ | version() | +-----------------+ | 10.3.15-MariaDB | +-----------------+ 1 row in set (0.003 sec) MariaDB [(none)]>
Well, all is well now. You have successfully installed MariaDB on CentOS 7.
You can check our other guides by following the links below;