> > 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
--
[email protected] mailing list
