From owner-freebsd-questions Sat Aug 31 9:23:17 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 3022C37B406 for ; Sat, 31 Aug 2002 09:23:09 -0700 (PDT) Received: from jive.SoftHome.net (jive.SoftHome.net [66.54.152.27]) by mx1.FreeBSD.org (Postfix) with SMTP id 988B943E3B for ; Sat, 31 Aug 2002 09:23:08 -0700 (PDT) (envelope-from gsfgf@softhome.net) Received: (qmail 18464 invoked by uid 417); 31 Aug 2002 16:23:03 -0000 Received: from shunt-smtp-out-0 (HELO softhome.net) (172.16.3.12) by shunt-smtp-out-0 with SMTP; 31 Aug 2002 16:23:03 -0000 Received: from gentoo.my-net-space.net ([66.32.121.31]) (AUTH: LOGIN gsfgf@softhome.net) by softhome.net with esmtp; Sat, 31 Aug 2002 10:23:02 -0600 Date: Sat, 31 Aug 2002 12:29:31 +0000 From: Jeff Jeter To: Rob Ellis Cc: freebsd-questions@freebsd.org Subject: Re: Mysql won't let me in Message-Id: <20020831122931.6c69c42a.gsfgf@softhome.net> In-Reply-To: <20020831160442.GB50932@web.ca> References: <20020831114147.39c550b7.gsfgf@softhome.net> <20020831160442.GB50932@web.ca> 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 it worked thx. On Sat, 31 Aug 2002 12:04:42 -0400 Rob Ellis wrote: > try: > > mysqladmin -u root -p create "mini" > > you should get prompted for the password. > > - rob > > On Sat, Aug 31, 2002 at 11:41:47AM +0000, 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)' > > > > mysqladmin create mini -u root --password=[********] > > mysqladmin: connect to server at 'localhost' failed > > error: 'Access denied for user: ' root@localhost' (Using password:NO)' > > > > mysqladmin create mini -u root > > mysqladmin: connect to server at 'localhost' failed > > error: 'Access denied for user: ' root@localhost' (Using password:NO)' > > > > > > 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