MySQL Instead of MariaDB

[1024kb]

This is actually the first time I've run across this issue where CB2.0 installed MariaDB instead of MySQL by default. I'm not sure if that's due to a recent change or because this is the first non-CentOS install I've done before (I'm using Debian this time around). But basically I'd like to use MySQL instead of MariaDB. I've read the other posts regarding support for MySQL 5.7 which I'm not concerned about - MySQL 5.5 or 5.6 would be fine with me. I just can't figure out how to switch from MariaDB to MySQL now. I don't have any production databases currently since this is a brand new install, so any solution would be fine with me.

I thought it might be as simple as setting the MySQL option to "yes" (it's currently set to "no") but I get an error when attempting this:

root@server01:/usr/local/directadmin/custombuild# ./build options | grep -i mysql
MySQL: no
MySQL backup: yes
MySQL backup directory: /usr/local/directadmin/custombuild/mysql_backups
MySQL compress backups: no
root@server01:/usr/local/directadmin/custombuild# ./build set mysql yes
yes is not a valid setting for mysql option.

Anyone mind pointing me in the right direction? Much appreciated!

 

[Richard G]

You have to set mysql to the version you want to use.
So like this should work (be sure to backup your databases first):

cd /usr/local/directadmin/custombuild
./build set mysql_inst mysql
./build set mysql 5.5 (if you want version 5.5.x)
./build update
./build mysql