[mythtv-users] Can't get remote frontend to connect

[Frank Phillips]

On Thu, Mar 3, 2011 at 5:29 PM, Harry Devine <lifter89 at comcast.net> wrote:

> hdevine at hdevine-faa:~$ mysql -u mythtv -p -h 192.168.1.200
> Enter password:
> ERROR 1045 (28000): Access denied for user 'mythtv'@'192.168.1.105'
> (using password: YES)
>
> Using the mysql client on the master be, I printed out the values in the
> user table of the mysql database:
>
> mysql> select Host,User,Password from user where user='mythtv'\g
> +---------------+--------+-------------------------------------------+
> | Host          | User   | Password                                  |
> +---------------+--------+-------------------------------------------+
> | localhost     | mythtv | *A56FCCF24B1776335AA9DC7ACDE28E92A20FC921 |
> | %             | mythtv | *A56FCCF24B1776335AA9DC7ACDE28E92A20FC921 |
> | 192.168.1.105 | mythtv | 9b9890430520b16e39afb3698ded2eb0          |
> +---------------+--------+-------------------------------------------+
> 3 rows in set (0.00 sec)
>

A quick google suggests doing a select password('password'); to compare the
hashes. Note that there are different hashes for '%' and '192.168.2.105'.
You may be using the former and it is trying to authenticate against the
latter.
Try getting in from 192.169.1.200 (localhost) as the mythtv user.

You are talking with the daemon, so its not a blocked port, and the grant
tables (grant/flush privileges) shouldn't affect your ability to login,
AFAIK.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.mythtv.org/pipermail/mythtv-users/attachments/20110303/d1fa6903/attachment.html