[mythtv-users] Myth Front End can't connect with database

Lan Barnes lan at falleagle.net
Thu Apr 5 00:54:27 UTC 2007


On Wed, April 4, 2007 4:53 pm, Bruce Markey wrote:
> Lan Barnes wrote:
> ...
>> OK, how does one go about "adding *all* my machine's names, addresses,
>> and
>> variations, to the mysql database"?
>
> You only need to add the ones it asks for. For me, this has
> only ever been 'localhost', the local hostname or the wildcard
> IP address.
>
>> Database error was:
>> Access denied for user 'mythtv'@'xena' (using password: YES)
>
> This says that a TCP connection was made but the application
> did not want to accept an unknown user for "'mythtv'@'xena'"
> I use "bind-address = 0.0.0.0" and using a specific address
> may affect how it resolves host names. I'm not sure.
>
> : bjm at moktoo ; cat ~/.mythtv/mysql.txt
> str DBHostName=nordtv
> str DBUserName=mythtv
> str DBPassword=mythtv
> str DBName=mythconverg
>
> and at "nordtv"
>
> : bjm at nordtv ; mysql -u root mysql
> mysql> select Host,User from user where user='mythtv';
> +-----------+--------+
> | Host      | User   |
> +-----------+--------+
> | 192.168.% | mythtv |
> | localhost | mythtv |
> | nordtv    | mythtv |
> +-----------+--------+
>
> accepts any connection from any other host.
>
> Finally (or firstly), MySQL docs and support are at
> http://www.mysql.com/ .
>
> Hope this helps,
>

It helps immensely. I have some digging to do, but I now know more aout
where to dig.

Just for my information, would all of this been unecessary if I had
installed/configured with the host name/IP addr in the first place? Or
would I have just gone through this exercise earlier, and without knowing
the reward awaiting me (for I have tasted Myth ... and I want more).

-- 
Lan Barnes

SCM Analyst              Linux Guy
Tcl/Tk Enthusiast        Biodiesel Brewer



More information about the mythtv-users mailing list