[mythtv-users] Problem with Ubuntu upgrade

[Jason Chambers]

On 25/10/2010 19:51, Damian wrote:
> On 23/10/2010 02:12, Bill Meek wrote:
>>
>>    mysql -umythtv -p mythconverg
> 
> This results in:
> ERROR 1045 (28000): Access denied for user 'mythtv'@'localhost' (using
> password: YES)

Hmm, you've previously ran this command before and it was successful
(http://www.gossamer-threads.com/lists/mythtv/users/457092#457092).

Have you been making other changes that you haven't posted about?  Or
changed something, then you reversed the change out again afterwards but
maybe didn't get it right? Or maybe re-keyed the above command and made
a typo?

(Sorry don't mean to sound accusing here - just don't want to go chasing
something that may not be relevant).

> 
>>    mysql -hlocalhost -umythtv -p mythconverg
> 
> This too results in
> ERROR 1045 (28000): Access denied for user 'mythtv'@'localhost' (using
> password: YES)
> 
> I tried both my root password and my mythtv password (which worked fine
> in MythtV until the Ubuntu upgrade) for both.

The user name your using here is mythtv.  So the password is the mythtv
user's password, not the root password.  Also unless you've changed the
password again since you posted the user table contents in your previous
emails the password is "mythtv".


>> If you're comfortable doing it, put the following in a file, make it
>> executable and run it.  Put the output in pastebin.com and put the
>> url in a response here.
>>

<snip>

> Here's the output:
> 
> http://www.gingermagic.com/misc/mythhelp.txt
> 

<quoting from url>

> 192.168.0.2	MythBox	# Added by NetworkManager
> 127.0.0.1	localhost.localdomain	localhost
> ::1	MythBox	localhost6.localdomain6	localhost6
> 127.0.1.1	MythBox
> ::1     ip6-localhost ip6-loopback

That shows your /etc/hosts file has MythBox resolving to both 127.0.0.1
and its external IP address of 192.168.0.2.

This can cause all sorts of confusion as its not guaranteed which one
MythBox will be resolved to.

Please remove the "127.0.1.1	MythBox" line, restart mysql (as it may
cache the lookups) and try connecting again:

$ mysql -u mythtv -p mythconverg

$ mysql -u mythtv -h mythbox -p mythconverg

If those don't work post the output of:

$ mysql -u root -p mysql
mysql>SELECT host, user, password, select_priv FROM user;

and

mysql>SELECT host, db, user, select_priv FROM db;


-- 
Regards,
Jason