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.60) (envelope-from ) id 1G5jNp-0000qe-90 for garchives@archives.gentoo.org; Wed, 26 Jul 2006 13:25:05 +0000 Received: from robin.gentoo.org (localhost [127.0.0.1]) by robin.gentoo.org (8.13.7/8.13.6) with SMTP id k6QDMjYF002933; Wed, 26 Jul 2006 13:22:45 GMT Received: from infoline.su (mail.infoline.su [83.217.192.4]) by robin.gentoo.org (8.13.7/8.13.6) with ESMTP id k6QDKUK5009127 for ; Wed, 26 Jul 2006 13:20:31 GMT Received: from baikal.iproducts.test ([87.228.103.40]) by infoline.su (infoline.su) (Cipher TLSv1:RC4-MD5:128) (MDaemon.PRO.v8.1.1.R) with ESMTP id md50002608804.msg for ; Wed, 26 Jul 2006 17:33:28 +0400 Received: from [10.10.0.1] (baikal.iproducts.test [10.10.0.1]) by baikal.iproducts.test (8.13.7/8.13.6) with ESMTP id k6QDKM2s014395 for ; Wed, 26 Jul 2006 17:20:22 +0400 Message-ID: <44C76C15.3040208@infoline.su> Date: Wed, 26 Jul 2006 17:20:21 +0400 From: Alexander Kirillov User-Agent: Thunderbird 1.5.0.4 (X11/20060516) 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 To: gentoo-user@lists.gentoo.org Subject: Re: [gentoo-user] mysql, bind and dns hostnames References: <200607261431.46439.sguglia@arrows.it> In-Reply-To: <200607261431.46439.sguglia@arrows.it> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Spam-Processed: infoline.su, Wed, 26 Jul 2006 17:33:28 +0400 (not processed: spam filter disabled) X-MDRemoteIP: 87.228.103.40 X-Return-Path: nevis2us@infoline.su X-MDaemon-Deliver-To: gentoo-user@lists.gentoo.org X-MDAV-Processed: infoline.su, Wed, 26 Jul 2006 17:33:28 +0400 X-Archives-Salt: e964c7de-4c09-4a0a-a2cb-bea6ae78b637 X-Archives-Hash: 26cd2b5caea55f1a6c1dc55d85b4baed > I just installed on PC1 (pc-0001.localarea) mysql and bind. locally all OK. > when I try to connect via phpmyadmin from PC2 (pc-0002.localarea), the > following error prompts: > > Host '192.168.0.2' is not allowed to connect to this MySQL server > > - on my server, I inserted a new record for host=pc-0002.localarea in > mysql.user table with the correct user&password, but it seems that somewhere > mysql can not to resolve client's IP. Of course, if I insert a new > host=192.168.0.2 record, it works fine, but I prefere to use hostnames. If you have net-dns/bind-tools installed what's the output of dig -x 192.168.0.2 ? Are you using FQDN in mysql tables? You should use GRANT statements instead of hacking mysql tables directly and FLUSH PRIVILEGES afterwards. HTH, Sasha -- gentoo-user@gentoo.org mailing list