From owner-freebsd-questions Sun Sep 1 12: 8:36 2002 Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.FreeBSD.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 3E2E537B405 for ; Sun, 1 Sep 2002 12:08:34 -0700 (PDT) Received: from jive.SoftHome.net (jive.SoftHome.net [66.54.152.27]) by mx1.FreeBSD.org (Postfix) with SMTP id 5080443E3B for ; Sun, 1 Sep 2002 12:08:33 -0700 (PDT) (envelope-from gsfgf@softhome.net) Received: (qmail 18590 invoked by uid 417); 1 Sep 2002 19:08:32 -0000 Received: from shunt-smtp-out-0 (HELO softhome.net) (172.16.3.12) by shunt-smtp-out-0 with SMTP; 1 Sep 2002 19:08:32 -0000 Received: from gentoo.my-net-space.net ([66.32.121.31]) (AUTH: LOGIN gsfgf@softhome.net) by softhome.net with esmtp; Sun, 01 Sep 2002 13:08:32 -0600 Date: Sun, 1 Sep 2002 15:16:54 +0000 From: Jeff Jeter To: "Corey Snow" Cc: freebsd-questions@freebsd.org Subject: Re: Mysql won't let me in -- Update Message-Id: <20020901151654.2ca551ad.gsfgf@softhome.net> In-Reply-To: <3D70C959.19129.39875B56@localhost> References: <20020831114147.39c550b7.gsfgf@softhome.net> <3D70C959.19129.39875B56@localhost> X-Mailer: Sylpheed version 0.8.1 (GTK+ 1.2.10; i686-pc-linux-gnu) Mime-Version: 1.0 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 I got it eorking locally, but when i try to connect remotely "mysql -h server" it hangs. How do i allow access. I can't connect w/ ftp, nfs, or telnet to this box either. my /etc/hosts.allow is "ALL : ALL : allow" On Sat, 31 Aug 2002 13:49:13 -0700 "Corey Snow" wrote: > On 31 Aug 2002, at 11:41, Jeff Jeter wrote: > > > I installed mysql, started it with safe_mysqld, and changed the root password w/ mysql admin. mysqladmin -u root password ******** now when i try to create a databas w/ mysql admin it won't accept a pass. > > > > mysqladmin create mini > > mysqladmin: connect to server at 'localhost' failed > > error: 'Access denied for user: ' root@localhost' (Using password:NO)' > > > > Try just > > %mysql -u root -p > > Which should prompt you for the password. You might also try > "root@servername" as the user ID, but that's a long shot. > > Corey > > To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message