From mboxrd@z Thu Jan 1 00:00:00 1970 Received: from lists.gentoo.org ([140.105.134.102] helo=robin.gentoo.org) by nuthatch.gentoo.org with esmtp (Exim 4.54) id 1Evifp-0005FI-Gm for garchives@archives.gentoo.org; Sun, 08 Jan 2006 22:06:01 +0000 Received: from robin.gentoo.org (localhost [127.0.0.1]) by robin.gentoo.org (8.13.5/8.13.5) with SMTP id k08M2DTw025484; Sun, 8 Jan 2006 22:02:13 GMT Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.197]) by robin.gentoo.org (8.13.5/8.13.5) with ESMTP id k08LwNF2032465 for ; Sun, 8 Jan 2006 21:58:24 GMT Received: by zproxy.gmail.com with SMTP id 4so4414022nzn for ; Sun, 08 Jan 2006 13:58:23 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=WXk7ZI18bapvX7zdLXKO/brw6OVUJqc7m2siJI8q8zbYfdL24oPunGkVtPJ+spEalNmy49Cy4FfKRaEiplhnB8LIn+jYevT8xyF5lWNsBoVfqJpg8/FVGunKwCapQHOfAR1m1E5URG1SIlZx6A5qTd9Lg1VEY31Sq9xEZk2GmsI= Received: by 10.64.150.20 with SMTP id x20mr2244304qbd; Sun, 08 Jan 2006 13:58:23 -0800 (PST) Received: by 10.65.163.16 with HTTP; Sun, 8 Jan 2006 13:58:23 -0800 (PST) Message-ID: <5bdc1c8b0601081358s51f643e9pde47ba5714acbcfa@mail.gmail.com> Date: Sun, 8 Jan 2006 13:58:23 -0800 From: Mark Knecht To: gentoo-user@lists.gentoo.org Subject: Re: [gentoo-user] OT - mysql (WAS: [Re: OT - Need help with mythfronted GUI]) In-Reply-To: <5bdc1c8b0601081354r431b8cc2p9bab4463e0e4cd0e@mail.gmail.com> Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Subscribe: List-Id: Gentoo Linux mail X-BeenThere: gentoo-user@gentoo.org Reply-to: gentoo-user@lists.gentoo.org MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Disposition: inline References: <1135878795.9187.17.camel@camille.espersunited.com> <5bdc1c8b0601081018x5dd916cw106d03ffd6632f42@mail.gmail.com> <1136747428.9839.20.camel@camille.espersunited.com> <5bdc1c8b0601081122t36ea0bcn99987383a4d59ce3@mail.gmail.com> <1136749004.9839.24.camel@camille.espersunited.com> <1136749283.9803.28.camel@camille.espersunited.com> <1136752137.9838.36.camel@camille.espersunited.com> <5bdc1c8b0601081246p6735ba5er2a351c1c9ab283c4@mail.gmail.com> <1136754802.9839.40.camel@camille.espersunited.com> <5bdc1c8b0601081354r431b8cc2p9bab4463e0e4cd0e@mail.gmail.com> Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by robin.gentoo.org id k08LwNF2032465 X-Archives-Salt: f5bd9a9a-4309-4d24-9d63-e70072ac383a X-Archives-Hash: a954117ee5bacf0bfcb1c4b6f173a207 > > 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