[mythtv-users] Can't get remote frontend to connect
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?
> 1. Per:
> 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?
> mythtv-users mailing list
> mythtv-users at mythtv.org
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?
More information about the mythtv-users