From owner-freebsd-questions  Sat Aug 31  9: 5:16 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 0454D37B400
	for <freebsd-questions@freebsd.org>; Sat, 31 Aug 2002 09:05:14 -0700 (PDT)
Received: from spin.web.net (spin.web.net [192.139.37.16])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 9C6BC43E3B
	for <freebsd-questions@freebsd.org>; Sat, 31 Aug 2002 09:05:13 -0700 (PDT)
	(envelope-from rob@web.net)
Received: by spin.web.net (Postfix, from userid 1000)
	id A8C5112E41A; Sat, 31 Aug 2002 12:04:42 -0400 (EDT)
Date: Sat, 31 Aug 2002 12:04:42 -0400
From: Rob Ellis <rob@web.ca>
To: Jeff Jeter <gsfgf@softhome.net>
Cc: freebsd-questions@freebsd.org
Subject: Re: Mysql won't let me in
Message-ID: <20020831160442.GB50932@web.ca>
Mail-Followup-To: Rob Ellis <rob@web.ca>,
	Jeff Jeter <gsfgf@softhome.net>, freebsd-questions@freebsd.org
References: <20020831114147.39c550b7.gsfgf@softhome.net>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <20020831114147.39c550b7.gsfgf@softhome.net>
User-Agent: Mutt/1.3.28i
Sender: owner-freebsd-questions@FreeBSD.ORG
Precedence: bulk
List-ID: <freebsd-questions.FreeBSD.ORG>
List-Archive: <http://docs.freebsd.org/mail/> (Web Archive)
List-Help: <mailto:majordomo@FreeBSD.ORG?subject=help> (List Instructions)
List-Subscribe: <mailto:majordomo@FreeBSD.ORG?subject=subscribe%20freebsd-questions>
List-Unsubscribe: <mailto:majordomo@FreeBSD.ORG?subject=unsubscribe%20freebsd-questions>
X-Loop: FreeBSD.ORG

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