From owner-freebsd-questions Mon Jan 28 19:29:37 2002 Delivered-To: freebsd-questions@freebsd.org Received: from mail.the-i-pa.com (mail.the-i-pa.com [151.201.71.132]) by hub.freebsd.org (Postfix) with SMTP id 1C13537B400 for ; Mon, 28 Jan 2002 19:29:35 -0800 (PST) Received: (qmail 70955 invoked from network); 29 Jan 2002 03:34:04 -0000 Received: from unknown (HELO proxy.pt.com) (151.201.71.209) by mail.the-i-pa.com with SMTP; 29 Jan 2002 03:34:04 -0000 Content-Type: text/plain; charset="iso-8859-1" From: Bill Moran Organization: Potential Technology To: "Ozzie Gurkan" , Subject: Re: Problem with connecting to mysql on another machine Date: Mon, 28 Jan 2002 21:56:58 -0500 X-Mailer: KMail [version 1.2] References: In-Reply-To: MIME-Version: 1.0 Message-Id: <02012821565803.09169@proxy.pt.com> Content-Transfer-Encoding: 8bit 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 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