Skip site navigation (1)Skip section navigation (2)
Date:      Wed, 25 Oct 2000 11:59:46 -0400 (EDT)
From:      Alexander V P <alex@big-blue.net>
To:        Kazu Kimura <kimura@ctc.ad.jp>
Cc:        questions@FreeBSD.ORG, freebsd-database@FreeBSD.ORG
Subject:   Re: Question on MySQL
Message-ID:  <Pine.BSF.4.05.10010251154460.11569-100000@borg.starbase.net>
In-Reply-To: <20001025155142.345F.KIMURA@ctc.ad.jp>

next in thread | previous in thread | raw e-mail | index | archive | help
hi,
i never installed mysql from ports but it seems that you're missing
starting tables. when you install mysql from sources, you run a script
that will create this tables for you (under scripts dir, it's called
mysql_installdb i think ). my advise is to download source code
from mysql site and install it. follow the procedure in install file and
you wont have no problem. what FreeBSD do you have (3.x, 4.x)? I hope this
helps.
alex


On Wed, 25 Oct 2000, Kazu Kimura wrote:

> 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
> 



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?Pine.BSF.4.05.10010251154460.11569-100000>