[mythtv-users] Remote frontend can connect to mysql database, nothing else can.

Dave davedog at mac.com
Sun Jan 16 23:21:19 EST 2005


On Jan 16, 2005, at 1:37 PM, PAUL WILLIAMSON wrote:

>>>> davedog at mac.com 1/16/2005 4:13:45 PM >>>
>
> <large snippage>
>
>> Couldn't open database
>> Unable to connect to database!
>> Driver error was [1/1045]:
>> QMYSQL3: Unable to connect
>> Database error was:
>> Access denied for user: 'mythtv at localhost' (Using password: YES)
>
> Looks like someone forgot something...

Yup! something somewhere, haha!

>
>>
>> The mythtv user hass all privs in mysql and mysql.txt looks like
>>
>> DBHostName=localhost
>> DBUserName=mythtv
>> DBPassword=I_have_the_correct_password_here
>> DBName=mythconverg
>>
> <more large snippage>
>
> You need to change the DBHostName=xxxxxxxx
> where the xxxxxxx is the name or ip address of
> your master backend.  I'd suggest ip, but I did
> have it working with a name too.  Works great
> until dns server goes down.  It also works if you
> put the master backend server name/ip in the front
> end /etc/hosts file.

Yeah I've had DBHostName as localhost, the IP address and as the name 
of the machine. Still no go. Anything else I can check?

Thanks!

-Dave



More information about the mythtv-users mailing list