Date: Sat, 19 Jan 2002 13:18:11 -0500 (EST) From: "Philip M. Gollucci" <gollucci@wam.umd.edu> To: Allen May <allen@daytondigital.net> Cc: freebsd-questions@FreeBSD.ORG Subject: Re: MySQL install errors Message-ID: <Pine.GSO.4.21.0201191317310.2892-100000@rac1.wam.umd.edu> In-Reply-To: <1b3a01c1a0e7$b9ff7260$0401a8c0@Hewey>
next in thread | previous in thread | raw e-mail | index | archive | help
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 <mysql-thread96773@lists.mysql.com> > To unsubscribe, e-mail <mysql-unsubscribe-allen=daytondigital.net@lists.mysql.com> > 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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?Pine.GSO.4.21.0201191317310.2892-100000>