From owner-freebsd-database Wed Oct 25 0:51:28 2000 Delivered-To: freebsd-database@freebsd.org Received: from stf1.ctc.ad.jp (stf1.ctc.ad.jp [210.158.0.8]) by hub.freebsd.org (Postfix) with ESMTP id C9C8A37B479 for ; Wed, 25 Oct 2000 00:51:25 -0700 (PDT) Received: from pc-kimura by stf1.ctc.ad.jp (8.9.3+3.1W/3.7W-00051514) with ESMTP id QAA22176; Wed, 25 Oct 2000 16:51:15 +0900 (JST) Date: Wed, 25 Oct 2000 16:49:18 +0900 From: Kazu Kimura To: Emil Thelin Subject: Re: Question on MySQL Cc: freebsd-database@FreeBSD.ORG In-Reply-To: References: <20001025155142.345F.KIMURA@ctc.ad.jp> Message-Id: <20001025163220.3465.KIMURA@ctc.ad.jp> MIME-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit X-Mailer: Becky! ver. 2.00 (beta 32) Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG Emil, Thank you for quick response. To tell the truth, before I did pkg_add, other person installed MySQL in other directory with normal make command. This is not for FreeBSD. But it seems there is something wrong. Then, I reviewed the manual of MySQL and found in FreeBSD case, we better install MySQL with pkg_add command. So I download the package file from www.freebsd.org. First time, it was failed because there was no "mysql_install_db". And I copied it from old installed directory. So, maybe with this fact, I see following. extract: /usr/local/share/mysql/spanish/errmsg.txt extract: /usr/local/share/mysql/swedish/errmsg.sys extract: /usr/local/share/mysql/swedish/errmsg.txt extract: execute '/usr/local/bin/mysql_install_db' <--- Creating db table Creating host table Creating user table Creating func table Creating tables_priv table Creating columns_priv table ERROR: 1050 Table 'db' already exists ERROR: 1062 Duplicate entry '%-test-' for key 1 ERROR: 1062 Duplicate entry '%-test\_%-' for key 1 ERROR: 1050 Table 'host' already exists ERROR: 1050 Table 'user' already exists ERROR: 1062 Duplicate entry 'localhost-root' for key 1 ERROR: 1062 Duplicate entry 'red.stf.ctc.ad.jp-root' for key 1 ERROR: 1062 Duplicate entry 'localhost-' for key 1 ERROR: 1062 Duplicate entry 'red.stf.ctc.ad.jp-' for key 1 ERROR: 1050 Table 'func' already exists ERROR: 1050 Table 'tables_priv' already exists ERROR: 1050 Table 'columns_priv' already exists PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! Do these error have problem? or mysql_install_db file was a wrong one? Regards, Kazu On Wed, 25 Oct 2000 09:21:08 +0200 (CEST) Emil Thelin wrote: > On Wed, 25 Oct 2000, Kazu Kimura wrote: > > > I have installed MySQL 3.22 client& server with pkg_add. It seems > > successful. > > > > Have you runned 'mysql_install_db' ? > > /e > > _________________________________________________ > Emil Thelin http://www.display-umea.se > Tel. 090 71 15 00 emil-t@display-umea.se > Mobil. 070 681 34 28 > - - - - - - - - - - - - - - - - - - - Kazu Kimura IP Network Engineering, CTC, Japan Phone +81-52-740-8101 Fax +81-52-740-8935 - - - - - - - - - - - - - - - - - - - - To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message