> > OK. I went to my terminal on catherine and put in the line you > suggested. Here's the output: > > catherine ~ # mysql -u mythtv -h 192.168.1.3 -p mythconverg > Enter password: > ERROR 1130 (00000): Host 'catherine.espersunited.com' is not allowed to > connect to this MySQL server
This suggests that the mythconverge database hasn't been properly modified with the GRANT ALL command we talked about earlier. One other possibility I found from rereading somuch of the painful thread I created 9 months ago was that I did have to restart mysql after doing the GRANT commands. DId you do that on the backend machine? /etc/init.d/mysql restart > > However, when I try it on camille it doesn't work either, unless I > remove the host entry: > > [EMAIL PROTECTED] ~ $ mysql -u mythtv -h 192.168.1.3 -p mythconverg Would it allow mysql -u mythtv -h localhost -p mythconverg > Enter password: > ERROR 1130 (00000): Host 'camille.espersunited.com' is not allowed to > connect to this MySQL server Ah....one other possibility I remember running into was that camille.espersunited.com is NOT the same as camille. mysql was VERY picky about names in my hosts file, etc. > [EMAIL PROTECTED] ~ $ mysql -u mythtv -p mythconverg Yes, this command does not attempt to bind over the network. (I think....don't trust me!!) > The correct address IS in my.cnf: > > [EMAIL PROTECTED] ~ $ cat /etc/mysql/my.cnf | grep 'bind-address' > bind-address = 192.168.1.3 > [EMAIL PROTECTED] ~ $ cat /etc/mysql/my.cnf | grep 'port' > port = 3306 > [mysqlimport] > port = 3306 > > So why can't I connect with the IP address? Mythsetup already has > 192.168.1.3 as the address of the backend server... > This is so similar to what I stuggled with for weeks. I think you're very close if we can just find the trick. Definately try restarting at least mysql and also mythbackend: /etc/init.d/mythbackend stop /etc/init.d/mythbackend status /etc/init'd/mysql restart /etc/init.d/mythbackend start /etc/init.d/mythbackend status Don't totally trust the Gentoo scripts to do this right. They may work or they may not. I remember last year having some troubles with the scripts and getting better results being very specific about what I wanted to happen. - Mark -- gentoo-user@gentoo.org mailing list
