From owner-freebsd-questions Sat Jan 19 10:18:30 2002 Delivered-To: freebsd-questions@freebsd.org Received: from po3.wam.umd.edu (po3.wam.umd.edu [128.8.10.165]) by hub.freebsd.org (Postfix) with ESMTP id 1987B37B41A for ; Sat, 19 Jan 2002 10:18:15 -0800 (PST) Received: from rac1.wam.umd.edu (IDENT:root@rac1.wam.umd.edu [128.8.10.141]) by po3.wam.umd.edu (8.9.3/8.9.3) with ESMTP id NAA19137; Sat, 19 Jan 2002 13:18:12 -0500 (EST) Received: from rac1.wam.umd.edu (IDENT:sendmail@localhost [127.0.0.1]) by rac1.wam.umd.edu (8.9.3/8.9.3) with SMTP id NAA03017; Sat, 19 Jan 2002 13:18:11 -0500 (EST) Received: from localhost (gollucci@localhost) by rac1.wam.umd.edu (8.9.3/8.9.3) with ESMTP id NAA03013; Sat, 19 Jan 2002 13:18:11 -0500 (EST) X-Authentication-Warning: rac1.wam.umd.edu: gollucci owned process doing -bs Date: Sat, 19 Jan 2002 13:18:11 -0500 (EST) From: "Philip M. Gollucci" To: Allen May Cc: freebsd-questions@FreeBSD.ORG Subject: Re: MySQL install errors In-Reply-To: <1b3a01c1a0e7$b9ff7260$0401a8c0@Hewey> 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 Because you actually want to do mysqladmin -u root password 'passwordhere' then mysqladmin -u root --password='passusedhere' ***************************************************************************** Philip M. Gollucci (p6m7g8) Web-site : http://www.p6m7g8.com E-mail : gollucci@wam.umd.edu Philip@p6m7g8.com Phone : 301.249.6261 (Home) 301.314.3118 (College) Major : Computer Science Minor : Classical & Jazz Performance Current Job : Science, Discovery, & the Universe Webmaster URL: http://www.sdu.umd.edu Resume : http://www.wam.umd.edu/~gollucci/resume.html ***************************************************************************** On Sat, 19 Jan 2002, Allen May wrote: > I just install MySQL on my FreeBSD 4.4 box using pkg_add -r mysql-host. > When it finished, it prompted with the info below. It is prompting me to do > a new password so I type in: > /usr/local/bin/mysqladmin -u root -p password 'passwordhere' > and it prompts me for a password. I repeat the password 'passwordhere' and I > get back to the command line. > > Now, if I do a: > > /usr/local/bin/mysqladmin -u root -h PerlDesk -p password 'new-password' > > It comes back with the following error: > > PerlDesk# /usr/local/bin/mysqladmin -u root -h MySERVER -p password > 'passwordhere' > Enter password: > /usr/local/bin/mysqladmin: at 'MySERVER' failed > error: 'Host 'MySERVER.DOMAIN.net' is not allowed to connect to this MySQL > server' > > Why do I get this error? > > Thanks > > -Allen May > > > Preparing columns_priv table > Installing all prepared tables > 020118 12:25:43 /usr/local/libexec/mysqld: Shutdown Complete > > > PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! > This is done with: > > /usr/local/bin/mysqladmin -u root -p password 'new-password' > /usr/local/bin/mysqladmin -u root -h MySERVER -p password 'new-password' > > > See the manual for more instructions. > > You can start the MySQL daemon with: > cd /usr/local ; /usr/local/bin/safe_mysqld & > > You can test the MySQL daemon with the benchmarks in the 'sql-bench' > directory: > cd sql-bench ; run-all-tests > > Please report any problems with the /usr/local/bin/mysqlbug script! > > The latest information about MySQL is available on the web at > http://www.mysql.com > Support MySQL by buying support/licenses at https://order.mysql.com > > mysql:*:1001: > You already have a group "mysql", so I will use it. > mysql::1000:1001::0:0:mysql:/home/mysql:/nonexistent > You already have a user "mysql", so I will use it. > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail > To unsubscribe, e-mail > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message