How to install MariaDB database in yum on CentOS 7

1. Install MariaDB repository

* Install MariaDB 10.0 on a 64-bit system

### CentOS 7.x 64-bit MariaDB 10.0 ##
Cat <EOF>/etc/yum. repos. d/MariaDB. repo
[Mariadb]
Name = MariaDB
Base url = http://yum.mariadb.org/10.0/rhel7-amd64
Gpgkey = https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
Gpgcheck = 1
EOF

------------ OR ------------

### CentOS 6.x 64-bit MariaDB 10.0 ##
Cat <EOF>/etc/yum. repos. d/MariaDB. repo
[Mariadb]
Name = MariaDB
Base url = http://yum.mariadb.org/10.0/rhel6-amd64
Gpgkey = https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
Gpgcheck = 1
EOF

------------ OR ------------

### CentOS 5.x 64-bit MariaDB 10.0 ##
Cat <EOF>/etc/yum. repos. d/MariaDB. repo
[Mariadb]
Name = MariaDB
Base url = http://yum.mariadb.org/10.0/rhel5-amd64
Gpgkey = https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
Gpgcheck = 1
EOF

------------ OR ------------

* Install MariaDB 5.5 on a 64-bit system

### CentOS 7.x 64-bit MariaDB 5.5 ##
Cat <EOF>/etc/yum. repos. d/MariaDB. repo
[Mariadb]
Name = MariaDB
Base url = http://yum.mariadb.org/5.5/rhel7-amd64
Gpgkey = https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
Gpgcheck = 1
EOF

------------ OR ------------

### CentOS 6.x 64-bit MariaDB 5.5 ##
Cat <EOF>/etc/yum. repos. d/MariaDB. repo
[Mariadb]
Name = MariaDB
Base url = http://yum.mariadb.org/5.5/rhel6-amd64
Gpgkey = https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
Gpgcheck = 1
EOF

------------ OR ------------

### CentOS 5.x 64-bit MariaDB 5.5 ##
Cat <EOF>/etc/yum. repos. d/MariaDB. repo
[Mariadb]
Name = MariaDB
Base url = http://yum.mariadb.org/5.5/rhel5-amd64
Gpgkey = https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
Gpgcheck = 1
EOF

2. Install MariaDB 10/5. 5

### CentOS 7/6. 6/5. 11 and Red Hat (RHEL) 7/6. 6/5. 11 ###
Yum install MariaDB-server

3. Start MariaDB server and set it to boot

### CentOS 7/6. 6/5. 11 and Red Hat (RHEL) 7/6. 6/5. 11 ###
Service mysql start
Chkconfig mysql on

4. MariaDB (MySQL) security settings

### Just follow the command line ###
/Usr/bin/mysql_secure_installation

5. Locally log on to MySQL database for testing

Mysql-u root-p

6. Modify the mysql root password

Mysql> use mysql
Mysql> UPDATE mysql. user SET password = PASSWORD ('passwd') WHERE User = 'root ';
Mysql> flush privileges;

Now, let's go here.