[mythtv-users] Xenial mysql 5.7 update

[Bill Meek]

On 04/09/2016 01:03 PM, Bill Meek wrote:
>
> Maybe the solution for MythTV would be: SET GLOBAL default_password_lifetime = 0;

Or, assuming this is a MythTV only DB, change:

     /etc/mysql/mysql.conf.d/mythtv.cnf

and add the line:

default_password_lifetime=0

which like the SET GLOBAL command makes the entire DB less secure,
with regards to password aging as it has been before 5.7.

SHOW VARIABLES LIKE 'default_password_lifetime'; proves
that the variable has been changed

And, here's another one. mysql.service uses a pre and post start
program named: /usr/share/mysql/mysql-systemd-start

which assumes the DB is in  /var/lib/mysql/mysql
which will work for most users, but for those of
use who moved it by changing datadir and not a
symbolic link, it will fail.

It also tries to ping the DB using mysqladmin, but
can't read /etc/mysql/debain.cnf because unlike Upstart,
it's user is already changed to mysql. mysql still
starts, there are just errors in journalctl.

-- 
Bill