[mythtv-users] Problem with Ubuntu upgrade

[Damian]

On 21/10/2010 23:13, Greg Oliver wrote:
> On Thu, Oct 21, 2010 at 4:58 PM, Damian<myth at surr.co.uk>  wrote:
>> On 21/10/2010 13:00, mythtv-users-request at mythtv.org wrote:
>>>
>>> Date: Thu, 21 Oct 2010 12:09:45 +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:<4CC01F79.1090802 at purplish-monkey.com>
>>> Content-Type: text/plain; charset=ISO-8859-1
>>>
>>> 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 readhttp://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
>>
>> Thanks for the responses! I'm starting to get somewhere I think.
>>
>> 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
>>
>> 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.
>
> The password field on the entry with % (that is a SQL wildcard)
> probably has a diferent password than the localhost entry ?  You can
> either cut and paste from the localhost entry into the % entry in
> phpmyadmin, or change it from the sql command line like previously
> posted.


Thanks for that Greg,

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?


>
>> 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?
>
> No - The '%' is everywhere
>
>> Sorry if phpmyadmin is looked down on, but it's a lot more user friendly
>> than the command line. I love the comand line when I know what I'm doing,
>> but not when I don't.
>>
>> What should I do next?
>>
>> Damian