Re: [gentoo-user] OT - mysql (WAS: [Re: OT - Need help with mythfronted GUI])

[Mark Knecht <markknecht@gmail.com>]

> > 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

-- 
gentoo-user@gentoo.org mailing list