From owner-freebsd-questions Tue May 29 18:38:57 2001 Delivered-To: freebsd-questions@freebsd.org Received: from clmboh1-smtp3.columbus.rr.com (clmboh1-smtp3.columbus.rr.com [65.24.0.112]) by hub.freebsd.org (Postfix) with ESMTP id EEF3B37B422 for ; Tue, 29 May 2001 18:38:54 -0700 (PDT) (envelope-from wmoran@iowna.com) Received: from iowna.com (dhcp065-024-023-038.columbus.rr.com [65.24.23.38]) by clmboh1-smtp3.columbus.rr.com (8.11.2/8.11.2) with ESMTP id f4U1Zbk27181; Tue, 29 May 2001 21:35:37 -0400 (EDT) Message-ID: <3B144ED5.F86EE61B@iowna.com> Date: Tue, 29 May 2001 21:37:25 -0400 From: Bill Moran X-Mailer: Mozilla 4.76 [en] (X11; U; FreeBSD 4.3-STABLE i386) X-Accept-Language: en MIME-Version: 1.0 To: Gerard Samuel Cc: FreeBSD Questions Subject: Re: mysql tcp connection References: <3B144374.996414E9@optonline.net> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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 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