Switching from MySQL to MariaDB on Ubuntu 14.04

I’ve known about MariaDB for a while, but because I wanted my development machines to match my production environments, I just stayed with MySQL. Today I found out that the production environments switched to MariaDB, so I searched around the internet to find out how to do the switch on my development machines. All are running Ubuntu 14.04, so I thought that as long as I could do it on one, it would be easy to do the rest. Well, that would be the case if there were good instructions somewhere, but I had to piece together a solution that worked for me, as I was getting error messages after following the advice of others.

The Terminal

As you know, all good things are done in the terminal. Open it up and run each line, answering Y when asked [Y/n]. When phpMyAdmin asks if you want to create a new database for configuration, tell it YES.

sudo apt-get remove --purge mysql-server mysql-client mysql-common
sudo apt-get autoremove
sudo apt-get autoclean
sudo apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xcbcb082a1bb943db
sudo add-apt-repository 'deb [arch=amd64,i386] http://sfo1.mirrors.digitalocean.com/mariadb/repo/10.1/ubuntu trusty main'
sudo apt-get update
sudo apt-get install software-properties-common mariadb-server mariadb-client libmariadbclient-dev libmariadbd-dev phpmyadmin php5-mysqlnd
sudo service apache2 restart

Edit the phpMyAdmin Config File

The config file for my phpMyAdmin is located at /etc/phpmyadmin/config.inc.php

// Change the auth type to config
$cfg['Servers'][$i]['auth_type'] = 'config';
// Add the next two lines
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
// Uncomment the following line
$cfg['Servers'][$i]['AllowNoPassword'] = TRUE;

To say that’s all there is to it would make it sounds like you can get away with not having any problems. I can’t be sure that all is not borked, but I’ll update this post if necessary. So far so good.

Posted December 22nd, 2015 in , , ,

Leave a comment