[mythtv-users] Myth Front End can't connect with database
bjm at lvcm.com
Wed Apr 4 23:53:50 UTC 2007
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
> 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
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
Hope this helps,
More information about the mythtv-users