[mythtv-users] Xenial mysql 5.7 update

[Bill Meek]

On 04/09/2016 12:04 PM, jksjdevelop wrote:
>
> The main problem however is that the root password cannot be null and user passwords timeout after 360 days.
> I can't find a way that works to get in as root so trying to reset the root password.

I'm looking too, just some ideas. My apt-get upgrades showed mysql held back
and it wasn't until I manually stopped it that I could apply the upgrade. Which
removed mysql 5.6. Installing mysql again select the 5.7 you're commenting on.

SELECT Host,User,authentication_string,password_expired,password_last_changed,password_lifetime,account_locked FROM user;

http://dev.mysql.com/doc/refman/5.7/en/grant-tables.html and see the section on
password_lifetime

http://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_default_password_lifetime
for a system wide solution.

http://dev.mysql.com/doc/refman/5.7/en/password-expiration-policy.html

Maybe the solution for MythTV would be: SET GLOBAL default_password_lifetime = 0;

-- 
Bill