Install mariadb on Centos 7 128MB Machine

Running database server on 128mb RAM machine was a challenging task.

My attempts to run mysql 5.7 failed as database often dont restart after reboot.

So i switched to mariadb. To install mariadb server i have to run following command as root

#yum update


#yum install  mariadb-server -y


This will install mariadb onto the server

#systemctl enable mariadb

#systemctl start mariadb

Test database if its working

#mysql

Set root password for database and allow remote root login if you are planning to do so

#mysql_secure_installation

Now restart the server and check if database is running or not

To give remote access to mysql you may have to run following command in sql prompt

GRANT ALL ON *.* TO root@'%' IDENTIFIED BY 'password';