Note: Test your site properly before using this in production.
Taking backup of current databases
As a precautionary we will first take backup of all databases using following simple command
wget https://ancillary-proxy.atarimworker.io?url=https%3A%2F%2Fraw.githubusercontent.com%2FMiteshShah%2Fadmin%2Fmaster%2Fbackup%2Fmysqldump.sh
bash mysqldump.sh
This script will take backup of all your databases at following location
ls -al /var/www/mysqldump
Stop MySQL service
Stop running MySQL service
service mysql stop
Install MariaDB
Use following official MariaDB link to install MariaDB. This installation will remove your current MySQL / Percona MySQL and install MariaDB.
MariaDB installation: https://ancillary-proxy.atarimworker.io?url=https%3A%2F%2Fdownloads.mariadb.org%2Fmariadb%2Frepositories%2F
Update MySQL root password
If you are not EasyEngine user you can skip this step
Open my.cnf file
vim ~/.my.cnf
and Update MySQL root password
[client]
user = root
password = new-password