From owner-freebsd-questions Thu Sep 27 7:31: 8 2001 Delivered-To: freebsd-questions@freebsd.org Received: from jason-n3xt.org (42.mujb.dlls.dllstxbk.dsl.att.net [12.98.249.42]) by hub.freebsd.org (Postfix) with ESMTP id 80EEF37B41A for ; Thu, 27 Sep 2001 07:31:00 -0700 (PDT) Received: from localhost (jason@localhost) by jason-n3xt.org (8.11.4/8.11.5) with ESMTP id f8REVkZ10025; Thu, 27 Sep 2001 14:31:46 GMT (envelope-from jason@jason-n3xt.org) Date: Thu, 27 Sep 2001 14:31:46 +0000 (GMT) From: Jason To: Lucas Bergman Cc: questions@freebsd.org Subject: Re: MySQL and Qmail In-Reply-To: <20010927085851.C89668@comp04.prc.uic.edu> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII 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 On Thu, 27 Sep 2001, Lucas Bergman wrote: > > 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 > Awesome that worked. Okay now I still can't seem to add domains to VPOPMAIL. I tried using the test domain "test.com" like it says in the instructions and I tried using my real domain. ~vpopmail/bin/vadddomain test.com Please enter password for postmaster: enter password again: could not connect to mysql server vswl_getpw: failed to select MySQL server has gone away mysql adduser failed vsql_getpw: failed select Any further ideas? TIA ---- Jason jason@jason-n3xt.org To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message