[mythtv-users] Problem with Ubuntu upgrade

[Damian]

On 22/10/2010 03:17, mythtv-users-request at mythtv.org wrote:
> Date: Fri, 22 Oct 2010 01:06:59 +0100
> From: Jason Chambers<lists at purplish-monkey.com>
> Subject: Re: [mythtv-users] Problem with Ubuntu upgrade
> To:mythtv-users at mythtv.org
> Message-ID:<4CC0D5A3.3070300 at purplish-monkey.com>
> Content-Type: text/plain; charset=ISO-8859-1
>
> On 22/10/2010 00:22, Damian wrote:
>> >  
>> >  In phpmyadmin, I have entered the mythtv password everywhere that I can
>> >  enter it relating to the mythtv@% user (ie, reset the password to the
>> >  one I know was right before the upgrade) and granted all access. I have
>> >  also added mythconverg specific privileges specifically and granted all
>> >  access.
>> >  
>> >  Do I have to add Table-specific privileges?
>> >  
>> >  mysql -u mythtv -p -h MythBox mythconverg
>> >  
>> >  still wont let me in.
>> >  
>> >  Anything else I can try?
> Unfortunately as you use phpadmin which is a graphical interface its
> very hard to spot any steps you may be adding/omitting or any notice
> anything unusual that we didn't expect.
>
> Could you please try using the command line?
Ok. I can see the benefits for anyone trying to help. I'll follow your 
commands to the letter.
> Its concise and you can
> accurately show what you are doing and the output you get back which
> helps those who are trying to help you.
>
> Firstly you say you can connect as root.  So run this to see the user
> set-up:
>
> $ mysql -u root -p mysql
> mysql>  SELECT host, user, password FROM user;
>
> If the (encrypted) passwords for the two mythtv entries are*different*
> then something went wrong with the password change.
They are the same.
> So run this to
> change the password from the command line:
>
> mysql>  SET PASSWORD FOR 'mythtv'@'%' = PASSWORD('whatever your password
> should be');
>
> If they are the*same*  then try:
>
> mysql>  flush privileges;
This returned:
Query OK, 0 rows affected (0.00 sec)

> Then exit the mysql client and try these two commands:
>
> $ mysql -u mythtv -p mythconverg
Yes, that got me in.
> (This uses the localhost connection and should work based on your use of
> phpadmin previously)
>
> $ mysql -u mythtv -h MythBox -p mythconverg
This returned:
ERROR 1045 (28000): Access denied for user 'mythtv'@'MythBox'
> (This is the proper remote connection that needs to succeed for MythTV
> to work)
>
> If this still fails re-run the following command and post the output
> back to the list:
>
> $ mysql -u root -p mysql
> mysql>  SELECT host, user, password FROM user;
Here's the output:
mysql> SELECT host, user, password FROM user;
+-----------+------------------+-------------------------------------------+
| host      | user             | password                                  |
+-----------+------------------+-------------------------------------------+
| localhost | root             | *62342D54FD9B128B41AF871C8133ECDC8D8D3EA3 |
| MythBox   | root             |                                           |
| 127.0.0.1 | root             |                                           |
| localhost |                  |                                           |
| MythBox   |                  |                                           |
| localhost | debian-sys-maint | *E70FD7D9D21BEC5D516800B84C6C8DBE602A1195 |
| localhost | mythtv           | *E850BD677DE03766879001862AC9AC261741D204 |
| %         | mythtv           | *E850BD677DE03766879001862AC9AC261741D204 |
| localhost | torrentflux      | *58AD98AB94E879519879F11472FC0B07B311264D |
+-----------+------------------+-------------------------------------------+
9 rows in set (0.00 sec)

> Regards,
> Jason
Thanks for helping Jason. Hopefully we'll get there soon.

Damian