[mythtv-users] Problem with Ubuntu upgrade

[Jason Chambers]

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

Then exit the mysql client and try these two commands:

$ mysql -u mythtv -p mythconverg

(This uses the localhost connection and should work based on your use of
phpadmin previously)

$ mysql -u mythtv -h MythBox -p mythconverg

(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;

Regards,
Jason