Skip site navigation (1)Skip section navigation (2)
Date:      Fri, 9 Mar 2001 18:53:27 +0600
From:      "Radoslav Vasilev" <rvasilev@uni-svishtov.bg>
To:        <stable@freebsd.org>
Subject:   can't add remote users on mysql323-server
Message-ID:  <006201c0a897$efa267e0$52ad44c1@unisvishtov.bg>

next in thread | raw e-mail | index | archive | help

[-- Attachment #1 --]

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 


[-- Attachment #2 --]
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=koi8-r" http-equiv=Content-Type>
<META content="MSHTML 5.00.2614.3500" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2><BR>The problem I've never had before is that I 
can't add remote new user on mysql-server 3.23 .</FONT></DIV>
<DIV><FONT face=Arial size=2>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).<BR>&nbsp;Doing plain telnet mysqlhost 3306 prints: <BR>'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)<BR>I'll appreciate&nbsp; any idea where the problem might be, 
any hint, whatever. I just can't afford new compilation. At least 
<BR></DIV></FONT></BODY></HTML>

Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?006201c0a897$efa267e0$52ad44c1>