[mythtv-users] importing existing recorded programs

[backuppc at sundquist.imapmail.org]

On Tue, 29 Dec 2009 Mike said:
> 
> OK, still, upgrade to the latest restore script. It will give you a
> much better error message and a means to see exactly why the DB login is
> failing (i.e. you can see DB hostname, username, and password to verify
> it's correct) 

Thanks Mike.

The newer version printed out the password mythtv was using to access
the database.

I couldn't log on to mysql at the command line using that password.

Going into mysql as root, I found:

mysql> select `Host`,`User`,`Password` from `user` WHERE `User` =
'mythtv';
+-----------+--------+-------------------------------------------+       
| Host      | User   | Password                                  |       
+-----------+--------+-------------------------------------------+       
| localhost | mythtv | *CC8F35F587CA5A556B4132C2407E556D92172FFC |       
| %         | mythtv | *57BCDA9886E934E718338C6BD6E71970EAB9FD24 |       
+-----------+--------+-------------------------------------------+       
2 rows in set (0.00 sec)  

So the passwords didn't match.

The "%" password was OK (reset it and the hash didn't change), but the
localhost needed resetting.  After that, it worked well.

Jon S.