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.
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.