Date: Wed, 20 Apr 2005 07:49:37 -0400 From: Bob Hall <rjhjr@cox.net> To: freebsd-questions@freebsd.org Subject: Re: MySQL Server died yesterday ! Message-ID: <20050420114936.GA94042@kongemord.krig.net> In-Reply-To: <4266398B.9000803@uk2.net> References: <20050420032237.3CA7616A4EE@hub.freebsd.org> <4266398B.9000803@uk2.net>
next in thread | previous in thread | raw e-mail | index | archive | help
On Wed, Apr 20, 2005 at 12:14:19PM +0100, Graham Bentley wrote: > Hello All ! > > I made quite a few changes to my system recently > but havent touched any MySQL specific stuff. > > When I came to check my forum it was dead > with an unable to connect error :( > > This is in the logs and is recorded every > time I reboot or start manaully with > > /usr/local/etc/rc.d/mysql-server.sh start > > 12:05:43 mysqld started > 12:05:44 InnoDB: Started > 12:05:44 Fatal error: Can't open privilege tables: Table 'mysql.host' > doesn't exist > 12:05:44 Aborting > 12:05:44 InnoDB: Starting shutdown... > 12:05:46 InnoDB: Shutdown completed > 12:05:46 /usr/local/libexec/mysqld: Shutdown Complete > > I have googled on this and read various sections of > the MySQl manual but cant seem to nail it - nothing seem specific > to my issue. > > Some links suggested reinitialising my DB but > am not sure how to go about that. This is a very MySQL specific question. You should post it to the MySQL mailing list. It's been a while since I used MySQL. The host table is in the MySQL database. There should be a directory called data, or something similar, and inside that there is a directory called mysql, and inside that there is a file called host, which contains the host table. Or at least, that's what I remember. Either that file is missing, or the system permissions on it have changed, or MySQL has changed access privileges on it. Or something. Check to make sure that it is there, and has the correct system permissions (ls -l). If it's not there, you may have to back up all your tables and reinstall. Or you may be able to reinstall just the host table. Further questions should go to a MySQL mailing list. Bob Hall
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20050420114936.GA94042>