[mythtv-users] mythtv-users Digest, Vol 91, Issue 84

[Damian]

On 22/10/2010 17:05, mythtv-users-request at mythtv.org wrote:
> Date: Fri, 22 Oct 2010 13:10:47 +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:<4CC17F47.2050108 at purplish-monkey.com>
> Content-Type: text/plain; charset=ISO-8859-1
>
> On 22/10/2010 12:51, Damian wrote:
>>> >>  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.
>> >
>> >  They are the same.
>> >
> OK so the password was changed successfully - it is now definitely the
> same as the password you use when connecting locally.
>
>> >  Here's the output:
>> >  mysql>  SELECT host, user, password FROM user;
>> >  +-----------+------------------+-------------------------------------------+
>> >  
>> >  | host      | user             |
>> >  password                                  |
>> >  +-----------+------------------+-------------------------------------------+
>> >  
>> >  | localhost | root             |
>> >  *62342D54FD9B128B41AF871C8133ECDC8D8D3EA3 |
>> >  | MythBox   | root
>> >  |                                           |
>> >  | 127.0.0.1 | root
>> >  |                                           |
>> >  | localhost |
>> >  |                                           |
>> >  | MythBox   |
>> >  |                                           |
> Ah, that "MythBox" entry with no value in the user column is an
> anonymous user connection.  MySQL connections match the most specific
> hostname*first*  so when your trying to connect its matching the
> anonymous user from MythBox, rather than the 'mythtv'@'%' entry that the
> permissions are set-up for.
>
> (See 5.4.4 of the MySQL Reference Manual,
> http://dev.mysql.com/doc/refman/5.1/en/connection-access.html)
>
> As you do not seem to know MySQL very well, I doubt that you have set-up
> MySQL this way deliberately, and MythTV certainly does not need this
> anonymous account.  Therefore I would just remove it:
>
> $ mysql -u root -p mysql
> mysql>  DROP USER ''@'MythBox';
>

This returned:
mysql> DROP USER ''@'MythBox';
Query OK, 0 rows affected (0.00 sec)

mysql> SELECT host, user, password FROM user;
now returns:

+-----------+------------------+-------------------------------------------+
| host      | user             | password                                  |
+-----------+------------------+-------------------------------------------+
| localhost | root             | *62342D54FD9B12AB41AF87CC8133ECDC8D8D3EA3 |
| MythBox   | root             |                                           |
| 127.0.0.1 | root             |                                           |
| localhost |                  |                                           |
| localhost | debian-sys-maint | *E70FD7D9D27BEC5D5D6800B84C6C8DBE602A1195 |
| localhost | mythtv           | *CC8F35F587CA5A596B4132C2407E556D92172FFC |
| %         | mythtv           | *CC8F35F587CA5A596B4132C2407E556D92172FFC |
| localhost | torrentflux      | *58AD98AB94E879529839F11472FC0B07B311264D |
+-----------+------------------+-------------------------------------------+
8 rows in set (0.00 sec)

but
damian at MythBox:~$ mysql -u mythtv -h MythBox -p mythconverg
Enter password:

still gives

ERROR 1045 (28000): Access denied for user 'mythtv'@'MythBox' (using 
password: YES)

Thanks again Jason .. we must be getting close!!!
Damian