From owner-freebsd-stable Fri Mar 9 10:59:43 2001 Delivered-To: freebsd-stable@freebsd.org Received: from lunatic.oneinsane.net (lunatic.oneinsane.net [66.42.61.27]) by hub.freebsd.org (Postfix) with ESMTP id CF3B637B71D for ; Fri, 9 Mar 2001 10:59:40 -0800 (PST) (envelope-from insane@lunatic.oneinsane.net) Received: by lunatic.oneinsane.net (Postfix, from userid 1000) id 107A31555C; Fri, 9 Mar 2001 09:00:29 -0800 (PST) Date: Fri, 9 Mar 2001 09:00:28 -0800 From: Ron 'The InSaNe One' Rosson To: stable@freebsd.org Subject: Re: can't add remote users on mysql323-server Message-ID: <20010309090028.A29376@lunatic.oneinsane.net> Reply-To: Ron Rosson Mail-Followup-To: stable@freebsd.org References: <006201c0a897$efa267e0$52ad44c1@unisvishtov.bg> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <006201c0a897$efa267e0$52ad44c1@unisvishtov.bg>; from rvasilev@uni-svishtov.bg on Fri, Mar 09, 2001 at 06:53:27PM +0600 X-Operating-System: FreeBSD lunatic.oneinsane.net 4.2-STABLE X-Moon: The Moon is Full X-Opinion: What you read here is my IMHO X-WWW: http://www.oneinsane.net X-GPG-FINGERPRINT: 3F11 DB43 F080 C037 96F0 F8D3 5BD2 652B 171C 86DB X-Uptime: 8:57AM up 10 days, 15:17, 1 user, load averages: 0.16, 0.13, 0.05 Sender: owner-freebsd-stable@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG Radoslav Vasilev (rvasilev@uni-svishtov.bg) 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 > Since this is a 4.2 machine I wonder if you have commented out: ALL : ALL : allow in your /etc/hosts.allow file. If you have then you might need to add an entry in there like so: mysqld : xxx.xxx.xxx.xxx : allow Just an idea and this is assuming that you have set the proper grants in the mysql server to be accessed from that host. TIA -- ------------------------------------------------------------------------------ Ron Rosson ... and a UNIX user said ... The InSaNe One rm -rf * insane@oneinsane.net and all was /dev/null and *void() ------------------------------------------------------------------------------ Does your train of thought have a caboose To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-stable" in the body of the message