From owner-freebsd-questions Tue Jan 29 8:15:45 2002 Delivered-To: freebsd-questions@freebsd.org Received: from hotmail.com (law2-oe25.hotmail.com [216.32.180.18]) by hub.freebsd.org (Postfix) with ESMTP id 1BC7237B419 for ; Tue, 29 Jan 2002 08:15:39 -0800 (PST) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Tue, 29 Jan 2002 08:15:39 -0800 X-Originating-IP: [206.98.143.251] From: "Ozzie Gurkan" To: References: <02012821565803.09169@proxy.pt.com> Subject: Re: Problem with connecting to mysql on another machine Date: Tue, 29 Jan 2002 11:15:36 -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 16:15:39.0101 (UTC) FILETIME=[30FB70D0:01C1A8E0] 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, to resolve my own problem, I decided to install the MySQL server on FreeBSD machine itself. It seems to work now. I still can't understand though why I couldn't get to my XP machine. I was able to get to the XP machine from my other windoze machine, but...It is a mute point now. I have transferred all of my data over to the FreeBSD machine. Ozzie ----- Original Message ----- From: "Ozzie Gurkan" To: Sent: Monday, January 28, 2002 10:46 PM Subject: Re: Problem with connecting to mysql on another machine > 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 > To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message