From owner-freebsd-questions Sat Jan 19 4:53: 4 2002 Delivered-To: freebsd-questions@freebsd.org Received: from mx1.nocpeople.net (mx1.nocpeople.net [216.29.244.16]) by hub.freebsd.org (Postfix) with ESMTP id A110137B404 for ; Sat, 19 Jan 2002 04:52:56 -0800 (PST) Received: from mail.daytondigital.net (mail.nocpeople.net [216.29.244.21]) by mx1.nocpeople.net (Postfix) with ESMTP id 0EDD653501 for ; Sat, 19 Jan 2002 07:49:43 -0500 (EST) Received: from Hewey [64.105.103.231] by mail.daytondigital.net (SMTPD32-6.06) id AB2A87A014A; Sat, 19 Jan 2002 07:48:42 -0500 Message-ID: <1b3a01c1a0e7$b9ff7260$0401a8c0@Hewey> From: "Allen May" To: Subject: MySQL install errors Date: Sat, 19 Jan 2002 07:49:25 -0500 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_1B37_01C1A0BD.D0DE7EB0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 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 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 To unsubscribe, e-mail = 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

I just install MySQL on my FreeBSD 4.4 box using pkg_add -r=20 mysql-host.
When it finished, it prompted with the info below. It is=20 prompting me to do
a new password so I type = in:
/usr/local/bin/mysqladmin=20 -u root -p password 'passwordhere'
and it prompts me for a password. = I repeat=20 the password 'passwordhere' and I
get back to the command = line.

Now,=20 if I do a:

/usr/local/bin/mysqladmin -u root -h PerlDesk -p = password=20 'new-password'

It comes back with the following = error:

PerlDesk#=20 /usr/local/bin/mysqladmin -u root -h MySERVER -p=20 password
'passwordhere'
Enter = password:
/usr/local/bin/mysqladmin: at=20 'MySERVER' failed
error: 'Host 'MySERVER.DOMAIN.net' is not allowed = to=20 connect to this MySQL
server'

Why do I get this=20 error?

Thanks

-Allen May

Preparing columns_priv = table
Installing all prepared tables
020118 12:25:43 =20 /usr/local/libexec/mysqld: Shutdown Complete

PLEASE REMEMBER = TO SET A=20 PASSWORD FOR THE MySQL root USER !
This is done=20 with:

/usr/local/bin/mysqladmin -u root -p password=20 'new-password'
/usr/local/bin/mysqladmin -u root -h MySERVER -p = password=20 'new-password'

See the manual for more = instructions.

You can=20 start the MySQL daemon with:
cd /usr/local ; = /usr/local/bin/safe_mysqld=20 &

You can test the MySQL daemon with the benchmarks in the=20 'sql-bench'
directory:
cd sql-bench ; run-all-tests

Please = report=20 any problems with the /usr/local/bin/mysqlbug script!

The latest=20 information about MySQL is available on the web at
http://www.mysql.com
Support MySQL = by buying=20 support/licenses at https://order.mysql.com

mysql= :*:1001:
You=20 already have a group "mysql", so I will use=20 it.
mysql::1000:1001::0:0:mysql:/home/mysql:/nonexistent
You = already have=20 a user "mysql", so I will use=20 it.

------------------------------------------------------= ---------------
Before=20 posting, please check:
http://www.mysql.com/manual.php<= /A> =20 (the manual)
http://lists.mysql.com/ &= nbsp; =20 (the list archive)

To request this thread, e-mail <mysql-thread96773@lists= .mysql.com>
To=20 unsubscribe, e-mail <mysql-unsubscribe-allen=3Ddaytondigital.net@lists.mysql.com>Trouble=20 unsubscribing? Try: http://lists.mysql.co= m/php/unsubscribe.php

------=_NextPart_000_1B37_01C1A0BD.D0DE7EB0-- To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message