From owner-freebsd-questions  Wed Oct 25  0: 0:34 2000
Delivered-To: freebsd-questions@freebsd.org
Received: from stf1.ctc.ad.jp (stf1.ctc.ad.jp [210.158.0.8])
	by hub.freebsd.org (Postfix) with ESMTP
	id 0AAD937B479; Wed, 25 Oct 2000 00:00:29 -0700 (PDT)
Received: from pc-kimura
	by stf1.ctc.ad.jp (8.9.3+3.1W/3.7W-00051514) with ESMTP id PAA08538;
	Wed, 25 Oct 2000 15:59:30 +0900 (JST)
Date: Wed, 25 Oct 2000 15:57:33 +0900
From: Kazu Kimura <kimura@ctc.ad.jp>
To: questions@freebsd.org, freebsd-database@freebsd.org
Subject: Question on MySQL
Message-Id: <20001025155142.345F.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-questions@FreeBSD.ORG
Precedence: bulk
X-Loop: FreeBSD.ORG

Hello,

I am a beginner of FreeBSD and MySQL.

I have installed MySQL 3.22 client& server with pkg_add.  It seems
successful.

But when I activate the mysql daemon, it will soon go down as follows.

red# pwd
/usr/local/bin
red# ./safe_mysqld
Starting mysqld daemon with databases from /var/db/mysql
mysqld daemon ended

In /var/db/mysql/red.err, I can see following.
red# tail /var/db/mysql/red.err
mysqld ended on  Wed Oct 25 15:41:04 JST 2000
mysqld started on  Wed Oct 25 15:41:42 JST 2000
001025 15:41:42  /usr/local/libexec/mysqld: Table 'mysql.host' doesn't exist
mysqld ended on  Wed Oct 25 15:41:42 JST 2000
mysqld started on  Wed Oct 25 15:46:01 JST 2000
/usr/local/libexec/mysqld  Ver 3.22.32 for -freebsd4.1 on i386
mysqld ended on  Wed Oct 25 15:46:01 JST 2000
mysqld started on  Wed Oct 25 15:56:29 JST 2000
001025 15:56:30  /usr/local/libexec/mysqld: Table 'mysql.host' doesn't exist
mysqld ended on  Wed Oct 25 15:56:30 JST 2000

In fact, there is no mysql.host in the machine.  What should I do?

Any suggestion is much appreciated.

Thanks in advance.

Kazu



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