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://raw.githubusercontent.com/MiteshShah/admin/master/backup/mysqldump.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://downloads.mariadb.org/mariadb/repositories/
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
