From owner-freebsd-questions Thu Sep 27 6:58:32 2001 Delivered-To: freebsd-questions@freebsd.org Received: from comp04.prc.uic.edu (comp04.prc.uic.edu [128.248.230.104]) by hub.freebsd.org (Postfix) with SMTP id 71FAF37B41A for ; Thu, 27 Sep 2001 06:58:29 -0700 (PDT) Received: (qmail 91096 invoked by uid 1000); 27 Sep 2001 13:58:51 -0000 Date: Thu, 27 Sep 2001 08:58:51 -0500 From: Lucas Bergman To: Jason Cc: questions@freebsd.org Subject: Re: MySQL and Qmail Message-ID: <20010927085851.C89668@comp04.prc.uic.edu> Reply-To: lucas@slb.to References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 1.0i In-Reply-To: ; from jason@jason-n3xt.org on Thu, Sep 27, 2001 at 01:43:06PM +0000 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'm having trouble with getting MySQL server working. After I > install it from the ports I tried to run the commands it said to > change the "root" passwd of the database. It gave me: > > /usr/local/bin/mysqladmin -u root -p password > Enter password: > /usr/local/bin/mysqladmin: connect to server at 'localhost' failed > error: 'Access denied for user: 'root@localhost' (Using password: YES)' If your MySQL installation is fresh, then there is no root password yet. Using the '-p' means that root has a password, so no matter what you enter at the 'Enter password' prompt, you will never authenticate with the server. (In MySQL, no password != zero-length password.) To tell MySQL that root has no password, throw away the '-p'. mysqladmin -u root password new-password Lucas To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message