[mythtv-users] frontend can't login into backend

R. G. Newbury newbury at mandamus.org
Tue Apr 19 22:41:48 UTC 2011

On 04/19/2011 01:08 PM, Jim Morton wrote:
> On 4/19/2011 12:01 PM, Mike Bennett wrote:
>> On 04/19/2011 09:25 AM, Raymond Wagner wrote:
>>> On 4/19/2011 10:02, Mike Bennett wrote:
>>>> On 04/18/2011 02:18 PM, Mike Bennett wrote:
>>>>> On 04/18/2011 01:09 PM, Jim Morton wrote:
>>>>>> On 4/18/2011 3:00 PM, Mike Bennett wrote:
>>>>>>> On 04/18/2011 12:28 PM, Raymond Wagner wrote:
>>>>>>>> On 4/18/2011 14:19, Mike Bennett wrote:
>>>>>>>>> But when I try to get access to the backend from another frontend
>>>>>>>>> box using the correct mythtv user and password it says it can't
>>>>>>>>> login. Any ideas?
>>>>>>>> The backend protocol does not use username and password, MySQL
>>>>>>>> does. It
>>>>>>>> sounds like you have not set up the proper credentials for your
>>>>>>>> remote
>>>>>>>> machines.
>>>>>>>> _______________________________________________
>>>>>>> So how would I check? on both boxes it is mythtv and mythtv.
>>>>>> http://www.mythtv.org/wiki/Category:MySQL
>>>>> Thanks Jim I will give that a try tonight when I get home.
>>>> Okay I tried the info on resetting the passwords and still the same
>>>> thing. I verified that I had the pin set to 0000 in the general setting
>>>> on the main myth setup. Now if I change the IP setting on the remote
>>>> frontend database ssetup to point to the host name myth.mbppg.com
>>>> instead of the actual IP then it seems to get past the login but then it
>>>> says "cannot find (ping) database". If I uncheck the ping it stops
>>>> responding and I had to stop the backend and then rerun the remote setup
>>>> and recheck the ping box then restart the backend just for the screen to
>>>> show back up.
>>> Are you sure you have MySQL configured to listen on the network?
>> No how would I do that?
> Did you follow the link I sent?
> http://www.mythtv.org/wiki/Category:MySQL
> here is a clip of the pertinent entry
> Q: When running mysqlcheck I get the error message "Access denied for
> user ..."
> A: The problem may be that you are using the wrong password. The
> following commands will change the mysql password to "mythtv":
> # mysql -u root -p mysql
> myqsl>  GRANT ALL PRIVILEGES ON *.* TO 'mythtv'@'localhost'
> mysql>  UPDATE user SET Password=PASSWORD('mythtv') WHERE user='mythtv';
> mysql>  quit
> Note that you will have to change the database password in the mythtv
> setup to "mythtv" once you get it running again.
> end of clip

No. The problem is that the grant is to 'mythtv'@'localhost'. As long as 
your extra frontends are on the same network try:

...to 'mythtv'@'192.168.1.%' thus allowing any 192.168.1.xx machine access.

              R. Geoffrey Newbury			

More information about the mythtv-users mailing list