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.