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

Harry Devine lifter89 at comcast.net
Mon Mar 7 13:54:36 UTC 2011


On 3/6/2011 11:52 PM, Bill Meek wrote:
> On Sun, 2011-03-06 at 20:29 -0500, Harry Devine wrote:
>> Anywhere else I can look?
> Hi;
>
> 1. Per:
>
>   http://dev.mysql.com/doc/refman/5.1/en/default-privileges.html
>
> you should do (on your FE/BE):
>
>   FLUSH PRIVILEGES;
>
> after a password change.
>
> 2. Then, you can 'break the problem in half' by trying the same
> command you're using on your laptop on the combined FE/BE like
> frankalso mentioned:
>
>   mysql -u mythtv -p -h 192.168.1.200
>
> Does that work?
>
> 3. Also, what is the result of frankalso's suggestion of doing:
>
>   SELECT PASSWORD('whatever-password-youre-using');
>
> Is is: *A56FCCF24B1776335AA9DC7ACDE28E92A20FC921?
>
> Bill
>
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://www.mythtv.org/mailman/listinfo/mythtv-users
>
I didn't do the "FLUSH PRIVILEGES" command yet as I'm afraid that it 
would wipe out what is in that table and working.  I tried #2 from my 
master backend (which is 192.168.1.200) and got the same error saying 
that "access denied for user 'mythtv'@'192.168.1.200'".  When I do #3 
using "SELECT User,Host,Password FROM user", I see that the mythtv users 
in there (there's 1 for localhost and 1 for %) have the password

*A56FCCF24B1776335AA9DC7ACDE28E92A20FC921 that you referenced above.

What does that mean?  Should I just do the FLUSH command?

Thanks,
Harry




More information about the mythtv-users mailing list