Date: Fri, 9 Mar 2001 19:30:11 +0600 From: "Radoslav Vasilev" <rvasilev@uni-svishtov.bg> To: <freebsd-stable@freebsd.org> Subject: can't add new remote user on mysql323-server Message-ID: <008001c0a89d$11169b80$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'm in habit of doing 'insert into user.... and flush privileges ' way of adding users on two other mysql servers(3.22) as well, but not on that machine.. 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 ways 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 my server ( tracking 4-Stable branch,) 2 weeks ago? '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>The problem I've never had before is that I can't add remote new user on mysql-server 3.23 . <DIV><FONT face=Arial size=2>I've got an FreeBSD 4-2 machine, and installed mysql as a port (databases/mysql323-server). I'm in habit of doing 'insert into user.... and flush privileges ' way of adding users on two other mysql servers(3.22) as well, but not on that machine..<BR> 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 ways 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 my server ( tracking 4-Stable branch,) 2 weeks ago?<BR>'ll appreciate any idea where the problem might be, any hint, whatever. I just can't afford new compilation. At least <BR></DIV></FONT></FONT></DIV></BODY></HTML>
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?008001c0a89d$11169b80$52ad44c1>