Date: Wed, 25 Oct 2000 16:49:18 +0900 From: Kazu Kimura <kimura@ctc.ad.jp> To: Emil Thelin <emil-t@display-umea.se> Cc: freebsd-database@FreeBSD.ORG Subject: Re: Question on MySQL Message-ID: <20001025163220.3465.KIMURA@ctc.ad.jp> In-Reply-To: <Pine.BSF.4.10.10010250920360.70296-100000@mailserver.display-umea.se> References: <20001025155142.345F.KIMURA@ctc.ad.jp> <Pine.BSF.4.10.10010250920360.70296-100000@mailserver.display-umea.se>
next in thread | previous in thread | raw e-mail | index | archive | help
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 <emil-t@display-umea.se> 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 <kimura@ctc.ad.jp> 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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20001025163220.3465.KIMURA>