Table 'mysql.host' doesn't exist

[cadbilbao]

Hi.

Working with mySQL 3.23.58 on Linux, I get this error when trying to start mysqld:
--------------------
060716 03:07:21 mysqld started
060716 03:07:21 /usr/local/mysql/libexec/mysqld: Table 'mysql.host' doesn't exist
060716 03:07:21 mysqld ended
---------------------

This Linux machine has been working ok for months, and it stopped suddenly.

I don't've any idea about how to fix it, and I don't find any '/etc/my.conf' file
into this machine. The install directory is '/usr/local/mysql'.

Thank you very much in advance.

 

[cadbilbao]

I created this very-simple '/etc/my.conf':
--------
[mysqld]
basedir=/usr/local/mysql
datadir=/usr/local/mysql/var
socket=/tmp/mysql.sock
-----------

But it doesn't still work.

'/usr/local/mysql/var' hosts the data, but within 'mysql' subdirectory, there are
only two files:
--------------
-rw-rw---- 1 mysql root 0 may 30 2005 func.MYD
-rw-rw---- 1 mysql root 8877 may 30 2005 tables_priv.frm
----------------

Where is 'host.frm', 'host.MYD' and 'host.MYI'?

 

[lgarner]

I think you need to restore from a backup. I don't know about 3.23 exactly, but there definitely should be user, host, db, and maybe columns_priv. If you were just missing the hosts table, I'd give you my create statement. That table's empty anyway on my system.

If you don't have a backup, maybe look at

http://www.oreillynet.com/databases/blog/2006/05/introducing_the_mysql_sandbox.html

I haven't seen this before, but it's one way to set up a parallel MySQL installation so you can copy the mysql.* tables to your production installation. Or, just install MySQL on a different host and copy them over. You'll have to recreate any data that was in them (user ids, passwords, etc). This is if you don't have a DB backup.

 

[KarveR]

Mysql is by default in /var/lib/mysql, whats there, anything?

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.