From owner-freebsd-questions Mon Jan 28 19:46:45 2002 Delivered-To: freebsd-questions@freebsd.org Received: from hotmail.com (law2-oe50.hotmail.com [216.32.180.48]) by hub.freebsd.org (Postfix) with ESMTP id 98AFF37B416 for ; Mon, 28 Jan 2002 19:46:40 -0800 (PST) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Mon, 28 Jan 2002 19:46:40 -0800 X-Originating-IP: [216.175.78.36] From: "Ozzie Gurkan" To: References: <02012821565803.09169@proxy.pt.com> Subject: Re: Problem with connecting to mysql on another machine Date: Mon, 28 Jan 2002 22:46:39 -0500 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Message-ID: X-OriginalArrivalTime: 29 Jan 2002 03:46:40.0598 (UTC) FILETIME=[8F8C0F60:01C1A877] 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 Actually, I think I have the permissions set correctly because I can get to the MySQL server from my other windoze machine with an authorization entry in the users table (on the server) as: root@192.168.1.73. All I did was to duplicate that entry for authorizing my FreeBSD machine (on the server): root@192.168.1.99. I can connect from my windoze client, but not from my FreeBSD client. I am still stomped. The mysql-gui (running on FreeBSD client) for X says "Lost connection to MySQL server during query." It is almost like it isn't finding it or something. However, I can telnet to the server and it will establish a connection. > On Monday 28 January 2002 22:21, Ozzie Gurkan wrote: > > > > I am having problems connecting to mysql server from my FreeBSD machine. > > > I have tried using mysqladmin from the command line with no avail. The process > > > never returns. I can telnet into port 3306 and the host answers (even though > > > it is very difficult to get out of the telnet session). If I connect from my > > > windoze machine, I have no problems whatsoever. Is there some network > > > setting I am missing in my kernel, because I can cvsup, surf the net and ftp > > > just fine from the FreeBSD machine? > > Are you sure the permissions on the MySQL server are set up to allow you to log > in remotely? > MySQL permissions are a little complicated. You can have multiple usernames > from different machines, each with a different set of permissions. If you haven't > added any users and issued a "grant" statement on the MySQL server, then your > default setup will be (at least this is how it is on a UN*X machine) root can log > in locally, and nobody else has any access. > Read the section of the MySQL manual regarding permissions and the GRANT > statement and then go over your permissions with a fine-toothed comb, it's very > easy to get them wrong. > Otherwise, check the logs on the MySQL server and see if anything looks suspicious > and try using the -v (verbose) option when running mysqladmin. > > -- > Bill Moran > Potential Technology technical services > http://www.potentialtech.com > > To Unsubscribe: send mail to majordomo@FreeBSD.org > with "unsubscribe freebsd-questions" in the body of the message > To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message