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
[-- Attachment #1 --] 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 [-- Attachment #2 --] <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=Content-Type content="text/html; charset=iso-8859-1"> <META content="MSHTML 6.00.2712.300" name=GENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=#ffffff> <DIV>I just install MySQL on my FreeBSD 4.4 box using pkg_add -r mysql-host.<BR>When it finished, it prompted with the info below. It is prompting me to do<BR>a new password so I type in:<BR>/usr/local/bin/mysqladmin -u root -p password 'passwordhere'<BR>and it prompts me for a password. I repeat the password 'passwordhere' and I<BR>get back to the command line.<BR><BR>Now, if I do a:<BR><BR>/usr/local/bin/mysqladmin -u root -h PerlDesk -p password 'new-password'<BR><BR>It comes back with the following error:<BR><BR>PerlDesk# /usr/local/bin/mysqladmin -u root -h MySERVER -p password<BR>'passwordhere'<BR>Enter password:<BR>/usr/local/bin/mysqladmin: at 'MySERVER' failed<BR>error: 'Host 'MySERVER.DOMAIN.net' is not allowed to connect to this MySQL<BR>server'<BR><BR>Why do I get this 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 /usr/local/libexec/mysqld: Shutdown Complete<BR><BR><BR>PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !<BR>This is done with:<BR><BR>/usr/local/bin/mysqladmin -u root -p password 'new-password'<BR>/usr/local/bin/mysqladmin -u root -h MySERVER -p password 'new-password'<BR><BR><BR>See the manual for more instructions.<BR><BR>You can start the MySQL daemon with:<BR>cd /usr/local ; /usr/local/bin/safe_mysqld &<BR><BR>You can test the MySQL daemon with the benchmarks in the 'sql-bench'<BR>directory:<BR>cd sql-bench ; run-all-tests<BR><BR>Please report any problems with the /usr/local/bin/mysqlbug script!<BR><BR>The latest information about MySQL is available on the web at<BR><A href="http://www.mysql.com">http://www.mysql.com</A><BR>Support MySQL by buying support/licenses at <A href="https://order.mysql.com">https://order.mysql.com</A><BR><BR>mysql:*:1001:<BR>You already have a group "mysql", so I will use it.<BR>mysql::1000:1001::0:0:mysql:/home/mysql:/nonexistent<BR>You already have a user "mysql", so I will use it.<BR><BR><BR><BR>---------------------------------------------------------------------<BR>Before posting, please check:<BR> <A href="http://www.mysql.com/manual.php">http://www.mysql.com/manual.php</A> (the manual)<BR> <A href="http://lists.mysql.com/">http://lists.mysql.com/</A> (the list archive)<BR><BR>To request this thread, e-mail <<A href="mailto:mysql-thread96773@lists.mysql.com">mysql-thread96773@lists.mysql.com</A>><BR>To unsubscribe, e-mail <<A href="mailto:mysql-unsubscribe-allen=daytondigital.net@lists.mysql.com">mysql-unsubscribe-allen=daytondigital.net@lists.mysql.com</A>><BR>Trouble unsubscribing? Try: <A href="http://lists.mysql.com/php/unsubscribe.php">http://lists.mysql.com/php/unsubscribe.php</A><BR><BR></DIV></BODY></HTML>;
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?1b3a01c1a0e7$b9ff7260$0401a8c0>