Date: Sat, 19 Jan 2002 07:49:25 -0500 From: "Allen May" <allen@daytondigital.net> To: <freebsd-questions@FreeBSD.ORG> Subject: MySQL install errors Message-ID: <1b3a01c1a0e7$b9ff7260$0401a8c0@Hewey>
next in thread | raw e-mail | index | archive | help
This is a multi-part message in MIME format. ------=_NextPart_000_1B37_01C1A0BD.D0DE7EB0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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=3Ddaytondigital.net@lists.mysql.com> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php ------=_NextPart_000_1B37_01C1A0BD.D0DE7EB0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2712.300" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV>I just install MySQL on my FreeBSD 4.4 box using pkg_add -r=20 mysql-host.<BR>When it finished, it prompted with the info below. It is=20 prompting me to do<BR>a new password so I type = in:<BR>/usr/local/bin/mysqladmin=20 -u root -p password 'passwordhere'<BR>and it prompts me for a password. = I repeat=20 the password 'passwordhere' and I<BR>get back to the command = line.<BR><BR>Now,=20 if I do a:<BR><BR>/usr/local/bin/mysqladmin -u root -h PerlDesk -p = password=20 'new-password'<BR><BR>It comes back with the following = error:<BR><BR>PerlDesk#=20 /usr/local/bin/mysqladmin -u root -h MySERVER -p=20 password<BR>'passwordhere'<BR>Enter = password:<BR>/usr/local/bin/mysqladmin: at=20 'MySERVER' failed<BR>error: 'Host 'MySERVER.DOMAIN.net' is not allowed = to=20 connect to this MySQL<BR>server'<BR><BR>Why do I get this=20 error?<BR><BR>Thanks<BR><BR>-Allen May<BR><BR><BR>Preparing columns_priv = table<BR>Installing all prepared tables<BR>020118 12:25:43 =20 /usr/local/libexec/mysqld: Shutdown Complete<BR><BR><BR>PLEASE REMEMBER = TO SET A=20 PASSWORD FOR THE MySQL root USER !<BR>This is done=20 with:<BR><BR>/usr/local/bin/mysqladmin -u root -p password=20 'new-password'<BR>/usr/local/bin/mysqladmin -u root -h MySERVER -p = password=20 'new-password'<BR><BR><BR>See the manual for more = instructions.<BR><BR>You can=20 start the MySQL daemon with:<BR>cd /usr/local ; = /usr/local/bin/safe_mysqld=20 &<BR><BR>You can test the MySQL daemon with the benchmarks in the=20 'sql-bench'<BR>directory:<BR>cd sql-bench ; run-all-tests<BR><BR>Please = report=20 any problems with the /usr/local/bin/mysqlbug script!<BR><BR>The latest=20 information about MySQL is available on the web at<BR><A=20 href=3D"http://www.mysql.com">http://www.mysql.com</A><BR>Support MySQL = by buying=20 support/licenses at <A=20 href=3D"https://order.mysql.com">https://order.mysql.com</A><BR><BR>mysql= :*:1001:<BR>You=20 already have a group "mysql", so I will use=20 it.<BR>mysql::1000:1001::0:0:mysql:/home/mysql:/nonexistent<BR>You = already have=20 a user "mysql", so I will use=20 it.<BR><BR><BR><BR>------------------------------------------------------= ---------------<BR>Before=20 posting, please check:<BR> <A=20 href=3D"http://www.mysql.com/manual.php">http://www.mysql.com/manual.php<= /A> =20 (the manual)<BR> <A=20 href=3D"http://lists.mysql.com/">http://lists.mysql.com/</A> &= nbsp; =20 (the list archive)<BR><BR>To request this thread, e-mail <<A=20 href=3D"mailto:mysql-thread96773@lists.mysql.com">mysql-thread96773@lists= .mysql.com</A>><BR>To=20 unsubscribe, e-mail <<A=20 href=3D"mailto:mysql-unsubscribe-allen=3Ddaytondigital.net@lists.mysql.co= m">mysql-unsubscribe-allen=3Ddaytondigital.net@lists.mysql.com</A>><BR= >Trouble=20 unsubscribing? Try: <A=20 href=3D"http://lists.mysql.com/php/unsubscribe.php">http://lists.mysql.co= m/php/unsubscribe.php</A><BR><BR></DIV></BODY></HTML> ------=_NextPart_000_1B37_01C1A0BD.D0DE7EB0-- 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?1b3a01c1a0e7$b9ff7260$0401a8c0>