Date: Thu, 27 Sep 2001 08:58:51 -0500 From: Lucas Bergman <lucas@slb.to> To: Jason <jason@jason-n3xt.org> Cc: questions@freebsd.org Subject: Re: MySQL and Qmail Message-ID: <20010927085851.C89668@comp04.prc.uic.edu> In-Reply-To: <Pine.BSF.4.21.0109271335220.8852-100000@jason-n3xt.org>; from jason@jason-n3xt.org on Thu, Sep 27, 2001 at 01:43:06PM %2B0000 References: <Pine.BSF.4.21.0109271335220.8852-100000@jason-n3xt.org>
next in thread | previous in thread | raw e-mail | index | archive | help
> 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 <new 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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20010927085851.C89668>