Upgrading MySQL 5.7 to MariaDB 10 on Ubuntu 18

FX: Stands up amid very large pile of yak hair

Right. If you're ever in the unfortunate space of needing to upgrade MySQL 5.7 to MariaDB 10 on Ubuntu 18.04 LTS, here's what to do and what not to do.

1) next time, upgrade to 20.04.5 LTS first, and most/all of this will go away :D

2) do NOT install the default mariadb-server-10.1 package, as its mysql_upgrade script does not know how to convert from mysql-5.7 tables.

3) Go here and select your Ubuntu version and a suitable MariaDB version.

4) Cut and paste the appropriate repo lines, and do what it says.

5) if it doesn't run mysql_upgrade for you, run it as root.

6) You may find that it hangs on starting the MariaDB server. This is an issue with apparmor, and can be fixed by following these instructions (reproduced here just in case of link rot).

sudo systemctl stop mariadb
echo "/usr/sbin/mysqld { }" | sudo tee /etc/apparmor.d/usr.sbin.mysqld
sudo apparmor_parser -v -R /etc/apparmor.d/usr.sbin.mysqld

The above should display Removal succeeded for "/usr/sbin/mysqld"

And then, to stop it reappearing on reboot:

sudo ln -s /etc/apparmor.d/usr.sbin.mysqld /etc/apparmor.d/disable/usr.sbin.mysqld

Finally:

sudo systemctl start mariadb

Comments

[Thomas Bnt]

Hello ! Don't hesitate to put colors on your codeblock like this example for have to have a better understanding of your code 😎

console.log('Hello world!');