From owner-freebsd-stable Fri Mar 9 8:57:22 2001 Delivered-To: freebsd-stable@freebsd.org Received: from equinox.datasyrge.net (ool-18ba2d21.dyn.optonline.net [24.186.45.33]) by hub.freebsd.org (Postfix) with ESMTP id B446C37B718 for ; Fri, 9 Mar 2001 08:57:18 -0800 (PST) (envelope-from jslivko@datasyrge.net) Received: from localhost (jslivko@localhost) by equinox.datasyrge.net (8.9.3/8.9.3) with ESMTP id MAA16293; Fri, 9 Mar 2001 12:00:19 -0500 Date: Fri, 9 Mar 2001 12:00:19 -0500 (EST) From: "Jonathan M. Slivko" To: Radoslav Vasilev Cc: stable@FreeBSD.ORG Subject: Re: can't add remote users on mysql323-server In-Reply-To: <006201c0a897$efa267e0$52ad44c1@unisvishtov.bg> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-stable@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG Have you tried adding an /etc/hosts.allow line for in.mysqld: your hostname/ip address? That might do the trick. -- Jonathan M. Slivko On Fri, 9 Mar 2001, Radoslav Vasilev wrote: > > The problem I've never had before is that I can't add remote new user on mysql-server 3.23 . > I've got an FreeBSD 4-2 machine, and installed mysql as a port (databases/mysql323-server). I've the habit ot doing 'insert into user.... and flush privileges ' way of adding users on two other mysql servers(3.22). > Doing plain telnet mysqlhost 3306 prints: > 'You are not wellcome to use mysqld from clienthost.domain.xx' , making me thing the privilege system is not updated after my insert. I've tried all the possible way of defining my host - as a clienthost, clienthost.domain.xx , ip-address etc. So, I wonder does it have something to do with updating of the server ( tracking 4-Stable branch) > I'll appreciate any idea where the problem might be, any hint, whatever. I just can't afford new compilation. At least > > -- |~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| | Jonathan M. Slivko | | Global IRC Operator, AsylumNet IRC Networks | | Systems Administrator, DataSyrge Internet Svces. | | Webpage: http://jslivko.datasyrge.net/ | | | | Come and check out AsylumNet: irc.asylum-net.org!| |~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-stable" in the body of the message