[mythtv-users] Mysql 8 status summary
jksjdevelop at gmail.com
Fri Nov 22 12:56:46 UTC 2019
Mysql 8 is the default in Ubuntu 19.10 and presumably in the upcoming LTS
Myth frontend and backend run without issues but there are problems with
1/Syntax change for grant statements
GRANT ALL ON mythconverg.* TO mythtv at localhost IDENTIFIED BY
Have to be done in two steps.
CREATE USER 'mythtv'@'localhost' IDENTIFIED BY 'password';
GRANT ALL ON mythconverg.* TO 'mythtv'@'localhost';
is useable but shows the following error
error string: !!NoTrans: SQL Error: Column 'modified' cannot be
error line: 98
3/The Android version of the frontend on Firestick 4K won't connect to
All the above issues are re-solved by swapping Mysql 8 for MariaDB 10.3
The process of removing MySQL and installing MariaDB is not for the
10 mins for somebody with experience took me several hours googling.
The main issue was that Mariadb wont start, it just times out on first
startup. Its a known issue that AppArmor kills it.
Simply rebooting resolves that issue.
I had to completely purge out mysql and all its configuration files to
get it to work then resetup and reload the database.
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the mythtv-users