[mythtv-users] Problem with Ubuntu upgrade

[Jason Chambers]

On 20/10/2010 09:46, Damian wrote:
> On 20/10/2010 01:37, David Whyte wrote:
>> On Wed, Oct 20, 2010 at 9:11 AM, Damian<myth at surr.co.uk>  wrote:

<snip>

>>> 2010-10-20 00:01:05.162 New DB connection, total: 1
>>> 2010-10-20 00:01:05.169 Unable to connect to database!
>>> 2010-10-20 00:01:05.176 Driver error was [1/1045]:
>>> QMYSQL: Unable to connect
>>> Database error was:
>>> Access denied for user 'mythtv'@'MythBox' (using password: YES)
>>>
>>
>> Maybe you need to make sure of the following:
>>
>> 1) You have your mythtv configuration files configured properly with
>> the correct mythtv DB credentials.  There are numerous files to check
>> here.
>> 2) Is your mysql binding to the correct network address and allowing
>> connections from within your LAN.

I don't think its 2) as that would give a different error. The message
would be "Can't connect to MySQL server on ..." wouldn't it?

The access denied messages suggests that the username/password/database
name are wrong.  See
http://dev.mysql.com/doc/refman/5.1/en/access-denied.html.

So either your ~/.mythtv/config.xml has the wrong values in it, or
something (probably the upgrade from the sounds of your original post)
has changed/removed the user's password or permissions.

> My understanding goes as far as agreeing with what needs to be done, but
> I have no idea what to actually check/change or how to go about it. What
> should I do next?

Forget running mythbackend etc. - instead go straight to a shell prompt
on the backend box and try the following command:

$ mysql -u mythtv -p -h MythBox mythconverg

When prompted for the password use the same value from ~/.mythtv/config.xml.

(if you have used a non-default database name then you need to replace
mythconverg - the correct value is in ~/.mythtv/config.xml too).

This should fail with the same "Access denied for user
'mythtv'@'MythBox' (using password: YES)".

Then read http://dev.mysql.com/doc/refman/5.1/en/privilege-system.html
to figure out how to set the user access correctly for your setup and
repeat the mysql command above until it connects OK.

Once the mysql command successfully connects, then MythTV should be fine
too.

Regards,
Jason