[mythtv-users] Problems with mariadb segfaults in latest ubuntu and maybe other distros

[Peter Bennett]

The latest mysql client library causes segfaults when a process using 
mariadb exits. See bug reports:

https://bugs.launchpad.net/ubuntu/+source/mysql-8.0/+bug/1877504
https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=961672

There does not seem to be any fix coming soon, based on comments in the 
bug reports. The bug reports imply that mysql should change their 
package to conform to mariadb. That is not likely to happen.

If upgrading to Ubuntu 20.04 make sure you are using mysql not mariadb, 
or else downgrade package libmysqlclient21 to the older version.

Steps to Switch from mariadb to mysql:
close mythbackend
backup database
sudo apt purge mariadb-common
sudo apt install mysql-server
set up user ids
run restore.

Peter