How to install MariaDB 10.4 on CentOS 7

[russ111]

MariaDB 10.4 is the current major stable version. The first stable release was in June 2019, and it will be supported until June 2024.
This Tutorial is tested on CentOS 7.

- First of all, update your OS

Code:

yum -y update

- Add MariaDB 10.4 repository. Create a new repo file /etc/yum.repos.d/mariadb.repo. The latest repos for all linux distros are always here:https://downloads.mariadb.org/mariadb/repositories

Code:

tee /etc/yum.repos.d/MariaDB.repo<<EOF
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.4/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1
EOF

- Install MariaDB Server

Code:

yum -y install MariaDB-server MariaDB-client

- Start MariaDB service

Code:

systemctl start mariadb

-Enable MariaDb service at system boot up

Code:

systemctl enable mariadb

- Secure MariaDB Install

Code:

mysql_secure_installation

Answer the questions as below

Code:

=====================================================================
NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB
SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!

Enter current password for root (enter for none):
OK, successfully used password, moving on...

Set root password? [Y/n] y
New password:
Re-enter new password:
Password updated successfully!
Reloading privilege tables..
... Success!

Remove anonymous users? [Y/n] y
... Success!

Disallow root login remotely? [Y/n] y
... Success!

Remove test database and access to it? [Y/n] y
- Dropping test database...
... Success!
- Removing privileges on test database...
... Success!

Reload privilege tables now? [Y/n] y
... Success!

Cleaning up...
Thanks for using MariaDB!
=====================================================================

- check MariaDB version

Code:

mysql -V