[mythtv-users] Mysql 8 status summary

[Bill Meek]

On 11/22/19 6:56 AM, John wrote:
> 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 the following
> 
> 1/Syntax change for grant statements
> 
>      GRANT ALL ON mythconverg.* TO mythtv at localhost IDENTIFIED BY "password";
> 
>      Have to be done in two steps.
> 
>      CREATE USER 'mythtv'@'localhost' IDENTIFIED BY 'password';
> 
>      GRANT ALL ON mythconverg.* TO 'mythtv'@'localhost';
> 
> 2/Mythweb
> 
>      is useable but shows the following error
> 
>       error string:  !!NoTrans: SQL Error: Column 'modified' cannot be null [#1048]!!
>       filename: /usr/local/share/mythtv/mythweb/classes/Database/Query/mysqlicompat.php
>       error line:  98
> 
> 3/The Android version of the frontend on Firestick 4K won't connect to the backend.

4/https://code.mythtv.org/trac/ticket/13516 (just fixed in master last night)

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



-- 
Bill