[mythtv-users] Resetting mysql password for mythtv user

Hika van den Hoven hikavdh at gmail.com
Sun Nov 13 14:22:11 UTC 2016


Hoi Simon,

Sunday, November 13, 2016, 2:24:53 PM, you wrote:

> 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?

A User is also Host specific, you need both. Try `select User, Host from user;`

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

Have you tried the SQL commands at
https://www.mythtv.org/wiki/Category:MySQL ? And if you did, you got
an error?

> Thanks for any help
> SImon.

A User is also Host specific. So `select User, Host from user;

Tot mails,
  Hika                            mailto:hikavdh at gmail.com

"Zonder hoop kun je niet leven
Zonder leven is er geen hoop
Het eeuwige dilemma
Zeker als je hoop moet vernietigen om te kunnen overleven!"

De lerende Mens



More information about the mythtv-users mailing list