<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Help please.<br>
I have been running 0.28 on Xenial for a couple of weeks without any
probs. However Xenial updated mysql to 5.7 yesterday which has
created a few issues. <br>
Mythweb has an issue <a
href="https://code.mythtv.org/trac/ticket/12713"><a class="moz-txt-link-freetext" href="https://code.mythtv.org/trac/ticket/12713">https://code.mythtv.org/trac/ticket/12713</a>
</a><br>
The main problem however is that the root password cannot be null
and user passwords timeout after 360 days.<br>
I can't find a way that works to get in as root so trying to reset
the root password.<br>
Following the script at <a
href="http://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html"><a class="moz-txt-link-freetext" href="http://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html">http://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html</a></a><br>
<br>
Stopping the server with <br>
sudo systemctl stop mysql<br>
then running the script<br>
ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';<br>
by putting the above in file mysqlreset.txt and then :-<br>
sudo mysqld_safe --init-file=/home/laptop/mysqlreset.txt<br>
sudo systemctl start mysql<br>
<br>
The above generates no errors but just does not work - any ideas?<br>
<br>
</body>
</html>