From owner-freebsd-questions Tue May 29 22: 7:53 2001 Delivered-To: freebsd-questions@freebsd.org Received: from mta6.srv.hcvlny.cv.net (mta6.srv.hcvlny.cv.net [167.206.5.17]) by hub.freebsd.org (Postfix) with ESMTP id 563AA37B423 for ; Tue, 29 May 2001 22:07:50 -0700 (PDT) (envelope-from trini0@optonline.net) Received: from optonline.net (ool-18be012f.dyn.optonline.net [24.190.1.47]) by mta6.srv.hcvlny.cv.net (iPlanet Messaging Server 5.0 Patch 2 (built Dec 14 2000)) with ESMTP id <0GE400CHAU8WOT@mta6.srv.hcvlny.cv.net> for questions@FreeBSD.ORG; Wed, 30 May 2001 01:07:44 -0400 (EDT) Date: Wed, 30 May 2001 01:07:46 -0400 From: Gerard Samuel Subject: Re: mysql tcp connection To: Bill Moran Cc: FreeBSD Questions Message-id: <3B148021.60CB7680@optonline.net> MIME-version: 1.0 X-Mailer: Mozilla 4.77 [en] (X11; U; Linux 2.2.12 i386) Content-type: text/plain; charset=us-ascii Content-transfer-encoding: 7BIT X-Accept-Language: en References: <3B144374.996414E9@optonline.net> <3B144ED5.F86EE61B@iowna.com> Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG Well I hunted the online doc, and found out how to add a user where they could log on from only my domain. It was a piece of cake after that to connect via tcp. This whole mysql thing is a lot. I jumped in too fast, need to get a book or something.... Bill Moran wrote: > Gerard Samuel wrote: > > > > Hey all. Im trying to use a GUI frontend on windows to control mysql on > > a box on > > my lan. > > Network tcp wise, everything is good. When I try to connect to the box, > > it gets denied access. > > I supplied the correct password, which Ive been using on the console. > > In /usr/local/bin/safe_mysqld, I have > > MYSQL_TCP_PORT=${MYSQL_TCP_PORT:-3306}. > > I tried connecting on that port, but no avail. > > What else needs to be done?? > > Thanks > > Quintinple check your MySQL rights. It's possible to have a user that > can access the server from the localhost, but not from any other host > (the root user is configured this way by default) You can even have > different passwords for the same user from different machines. > MySQL has very complex security. This one feature alone is enough to > confuse anyone. I recommend using a GRANT command to create an entirely > new user with access from any host, if you can then connect as this > user, you know it's the MySQL privies that are causing trouble. > > -Bill > > -- > If a bird in the hand > is worth two in the bush, > then what can I get for > two hands in the bush? To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message