Date: Fri, 9 Mar 2001 09:00:28 -0800 From: Ron 'The InSaNe One' Rosson <insane@lunatic.oneinsane.net> To: stable@freebsd.org Subject: Re: can't add remote users on mysql323-server Message-ID: <20010309090028.A29376@lunatic.oneinsane.net> In-Reply-To: <006201c0a897$efa267e0$52ad44c1@unisvishtov.bg>; from rvasilev@uni-svishtov.bg on Fri, Mar 09, 2001 at 06:53:27PM %2B0600 References: <006201c0a897$efa267e0$52ad44c1@unisvishtov.bg>
next in thread | previous in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20010309090028.A29376>