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

[Michael Sullivan]

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@g.o mailing list