[mythtv-users] Database issues
watkinshome at gmail.com
Sun Feb 4 23:08:56 UTC 2007
On 04/02/07, shacky <shacky83 at gmail.com> wrote:
> I installed MythTV 0.20 on Ubuntu 6.06 from the Ubuntu repositories.
> I have some database issues, because I'm getting a lot of "Unable to connect
> to database!" errors when I try to start mythtv-setup and mythbackend.
> I'm setting up a network backend, and I wish MySQL to bind the ethernet IP
> address too (192.168.1.100), not only the localhost IP, so I setted up
> "bind-address = 192.168.1.100" in MySQL's my.cnf, but now MySQL doesn't bind
> the localhost address, so I have to tell MythTV to use 192.168.1.100 as
> MySQL address.
> I setted up "DBHostName= 192.168.1.100" in /etc/mythtv/mysql.txt, but I
> didn't solve the problem.
> If I setup MySQL to bind the localhost address it works well.
> Could you help me to solve this problem, please?
Not sure about Ubuntu, but on my Fedora setup the active mysql.txt is
the frontend user's /home/.mythtv/mysql.txt.
Also, have you granted mysql access to the network?
More information about the mythtv-users