[mythtv-users] Resetting mysql password for mythtv user

[Simon Waldman]

Hi list,

I recently reinstalled my MythTV machine (it was easier, with my limited
knowledge, than fixing everything that was broken from a number of upgrades
over the years).

Foolishly, I forgot to write down the database password before I did this -
so the new Mythbuntu installation has put a new password in config.xml, and
hence when I restored my old db the password was incorrect.

https://www.mythtv.org/wiki/Category:MySQL has instructions for resetting
the db password. However, I think this is out of date - because the "user"
table in my new install doesn't have a "password" field. I've also noticed
that somehow my db has two users called "mythtv", which doesn't sound like
a good thing:

mysql> select User from user;
+------------------+
| User             |
+------------------+
| mythtv           |
| debian-sys-maint |
| mysql.sys        |
| mythtv           |
| root             |
+------------------+
5 rows in set (0.00 sec)


So, two questions - and sorry if these are more MySQL questions than MythTV
ones:

1. Should I remove one of these users? If so, how? And how to tell which
one?

2. How can I reset the password for the user that is left?

Thanks for any help
SImon.

-- 
Simon Waldman
swaldman at firecloud.org.uk
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20161113/c2ae208e/attachment.html>