[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