From owner-freebsd-questions@FreeBSD.ORG Mon Feb 9 04:54:48 2004 Return-Path: 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 5965A16A4CE for ; Mon, 9 Feb 2004 04:54:48 -0800 (PST) Received: from munk.nu (mail.munk.nu [213.152.51.194]) by mx1.FreeBSD.org (Postfix) with ESMTP id 1BD5843D1F for ; Mon, 9 Feb 2004 04:54:48 -0800 (PST) (envelope-from munk@munk.nu) Received: from munk by munk.nu with local (Exim 4.30; FreeBSD) id 1AqAw3-0005Ik-HU; Mon, 09 Feb 2004 12:54:47 +0000 Date: Mon, 9 Feb 2004 12:54:47 +0000 From: Jez Hancock To: Stefan Moro Message-ID: <20040209125447.GA19665@users.munk.nu> Mail-Followup-To: Stefan Moro , freebsd-questions@freebsd.org References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.4.1i Sender: Jez Hancock cc: freebsd-questions@freebsd.org Subject: Re: mysql40 and FBSD 4.9 X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 09 Feb 2004 12:54:48 -0000 On Mon, Feb 09, 2004 at 12:54:06PM +0100, Stefan Moro wrote: > > I'm trying to setup mysql40. I installed it from the ports via the > mysql40-server port. The installation went just fine. Afetr the > installation I was trying to set the mysql root-users password with > mysqladmin -u root password 'new-password' This sound correct. > when i tried that I got the following message: > > mysqladmin: connect to server at 'localhost' failed > error: 'Access denied for user: 'root@localhost' (Using password: NO)' Have you tried actually connecting to mysql without a password? IIRC when mysql is first installed (been a while now :P), the initial root password is blank. Try just typing 'mysql' - if you get to the 'mysql>' prompt successfully then no password has been set. I'm thinking though that if you're getting that error then a password must have been set somehow... If you really can't figure out how to get in there's a guide to resetting the root mysql password here: http://www.mysql.com/doc/en/Resetting_permissions.html Good luck :P -- Jez Hancock - System Administrator / PHP Developer http://munk.nu/ http://jez.hancock-family.com/ - Another FreeBSD Diary http://ipfwstats.sf.net/ - ipfw peruser traffic logging