On Sun, 2006-01-08 at 13:58 -0800, Mark Knecht wrote: > > > What instructions? Are you referring to the GRANT line? I did that > > > yesterday. As for the mythbackend server IP, I set that two or three > > > days ago. It's in the database correctly: > > > > > > mysql> select * from settings WHERE value = 'BackendServerIP'; > > > +-----------------+-------------+----------+ > > > | value | data | hostname | > > > +-----------------+-------------+----------+ > > > | BackendServerIP | 192.168.1.3 | camille | > > > +-----------------+-------------+----------+ > > > 1 row in set (0.00 sec) > > > > > > What else do I need to do? > > > > Again, I'm not that good on this stuff but it's this basic command: > > > > The specific grant command is this one, or something like it: > > > > % mysql -u root -p > > mysql> GRANT ALL PRIVILEGES ON mythconverg.* TO 'mythtv'@'remotehost' > > IDENTIFIED BY 'password' > > > > Before you do that make sure you have camille's address in > > /etc/mysql/my.cnf: > > > > # keep secure by default! > > bind-address = 192.168.1.3 > > port = 3306 > > # this can make it even more secure: > > > > Make sure you have 192.168.1.3 in the mythsetup stuff for the server. > > > > At this point you should try logging into the mysql server from a > > terminal on both the server and your wife's machine. If you cannot log > > in then neither can Myth. From my terminal on a frontend only PC: > > (default password was mythtv on my system) > > > > dragonfly ~ # mysql -u mythtv -h 192.168.1.55 -p mythconverg > > Enter password: > > Reading table information for completion of table and column names > > You can turn off this feature to get a quicker startup with -A > > > > Welcome to the MySQL monitor. Commands end with ; or \g. > > Your MySQL connection id is 123 to server version: 4.0.25 > > > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > > > > mysql> exit > > Bye > > dragonfly ~ # > > > > Hope this helps, > > Mark > > > > Note that you can also check that mysql is even listening on the > correct port by running netstat on the backend machine: > > dragonfly ~ # netstat -apn | grep mysql > tcp 0 0 192.168.1.55:3306 0.0.0.0:* > LISTEN 6493/mysqld > tcp 0 0 192.168.1.55:3306 192.168.1.14:1343 > ESTABLISHED 6493/mysqld > tcp 0 0 192.168.1.55:3306 192.168.1.14:1401 > ESTABLISHED 6493/mysqld > tcp 0 0 192.168.1.55:3306 192.168.1.14:1400 > ESTABLISHED 6493/mysqld > unix 2 [ ACC ] STREAM LISTENING 9281 6493/mysqld > /var/run/mysqld/mysqld.sock > unix 3 [ ] STREAM CONNECTED 106522 6493/mysqld > /var/run/mysqld/mysqld.sock > unix 3 [ ] STREAM CONNECTED 106520 6493/mysqld > /var/run/mysqld/mysqld.sock > unix 3 [ ] STREAM CONNECTED 104027 6493/mysqld > /var/run/mysqld/mysqld.sock > unix 3 [ ] STREAM CONNECTED 9913 6493/mysqld > /var/run/mysqld/mysqld.sock > unix 3 [ ] STREAM CONNECTED 9725 6493/mysqld > /var/run/mysqld/mysqld.sock > unix 3 [ ] STREAM CONNECTED 9652 6493/mysqld > /var/run/mysqld/mysqld.sock > unix 3 [ ] STREAM CONNECTED 9577 6493/mysqld > /var/run/mysqld/mysqld.sock > dragonfly ~ # > > Cheers, > Mark >
All this looks right to me: camille mysql # netstat -apn | grep mysql tcp 0 0 192.168.1.3:3306 0.0.0.0:* LISTEN 2102/mysqld unix 2 [ ACC ] STREAM LISTENING 193048 2102/mysqld /var/run/mysqld/mysqld.sock unix 3 [ ] STREAM CONNECTED 193087 2102/mysqld /var/run/mysqld/mysqld.sock unix 3 [ ] STREAM CONNECTED 193085 2102/mysqld /var/run/mysqld/mysqld.sock -- gentoo-user@gentoo.org mailing list
