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

[Jim Morton]

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'
-> IDENTIFIED BY 'mythtv' WITH GRANT OPTION;
mysql> UPDATE user SET Password=PASSWORD('mythtv') WHERE user='mythtv';
mysql> FLUSH PRIVILEGES;
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

-- 
_________________________________________________________

Jim Morton