[mythtv-users] Problem with Ubuntu upgrade

[Jason Chambers]

On 21/10/2010 22:58, Damian wrote:
> Here are the steps I've taken:
> 
> 1) Checked that I can log in to phpmyadmin as root. I can.
> 
> 2) Checked that I can log in to phpmyadmin as mythtv using the password
> found in ~/.mythtv/config.xml. I can

MySQL users are sort of host specific.  The 'mythtv'@'%' and
'mythtv'@'localhost' are completely independent and therefore can have
different connection problems.

If phpadmin is installed on the same box as MySQL itself then then fact
that you can log in as the mythtv user does not prove anything, as its
probably using the localhost user.

> 2) Ran:
> mysql -u mythtv -p -h MythBox mythconverg
> and got:
> Access denied for user 'mythtv'@'MythBox' (using password: YES)
> 
> 3) Logged into phpmyadmin as root and went to the privileges section.
> I could see 2 mythtv users in there. One had the host '%' and one had
> the host 'localhost' (neither had the host 'MythBox').
> Both just had 'Usage' listed under privilages, so I edited them and
> clicked on 'Check All' to grant all privilages.
> 
> I was hopeful that this would work, but:
> mysql -u mythtv -p -h MythBox mythconverg
> still returned:
> Access denied for user 'mythtv'@'MythBox' (using password: YES)
> 
> Do I need to set up another user with 'MythBox' as the host?

The 'mythtv'@'%' user will include the MythBox host so you don't need to
add another host.

I would try resetting the password on the 'mythtv'@'%' account and then
test it by trying the command line again;

$ mysql -u mythtv -p -h MythBox mythconverg

-- 
Regards,
Jason