HomeCentOSCentOS 7Installing MariaDB 5.5 on CentOS 7

Installing MariaDB 5.5 on CentOS 7

MariaDB frees companies from the costs, constraints and complexity of proprietary databases, enabling them to reinvest in what matters most – developing innovative, customer-facing applications rapidly. Trusted by organizations like Deutsche Bank, DBS Bank, Nasdaq, Red Hat, ServiceNow, Verizon and Walgreens – MariaDB meets the same core requirements as proprietary databases, but at a fraction of the cost.

How to Install

yum install mariadb-server -y

Start Mariadb Service

systemctl start mariadb.service

Check MariaDB Status

systemctl status mariadb.service

Configure MariaDB Service

mysql_secure_installation

Enter current password for root (enter for none): Press Enter

Set root password? [Y/n] y

New password:
Re-enter new password:

Remove anonymous users? [Y/n] y

Disallow root login remotely? [Y/n] y

Remove test database and access to it? [Y/n] y

Reload privilege tables now? [Y/n] y

Allow MariaDB to automatically take username and password from a file. Create configuration file as below

vi /root/.my.cnf

Add

[client]
user=root
password=Your-Mysql-Password

Now type mysql in shell to see if everything is working fine.

You have no successfully completed installation of MariaDB version 5.5. In next article I will show how to upgrade it.

Must Read