mysql.host doesn't exist Again

[alexanderff]

Hi!

When I run the daemon mysqld I have the error mysql.host doesn't exist.

I run the script mysql_install_db and when I run the mysqld I get the same error.

The privilegies in /var/lib/mysql it's ok

Sorry for my english, I speak portuguese.

[Ph0eniX]

Can you get into MySQL at all ...I mean, does MySQLd start? ...if so you can just create the host table manually:

CREATE TABLE mysql.host (
Host char(60) binary NOT NULL default '',
Db char(64) binary NOT NULL default '',
Select_priv enum('N','Y') NOT NULL default 'N',
Insert_priv enum('N','Y') NOT NULL default 'N',
Update_priv enum('N','Y') NOT NULL default 'N',
Delete_priv enum('N','Y') NOT NULL default 'N',
Create_priv enum('N','Y') NOT NULL default 'N',
Drop_priv enum('N','Y') NOT NULL default 'N',
Grant_priv enum('N','Y') NOT NULL default 'N',
References_priv enum('N','Y') NOT NULL default 'N',
Index_priv enum('N','Y') NOT NULL default 'N',
Alter_priv enum('N','Y') NOT NULL default 'N',
PRIMARY KEY (Host,Db)
) TYPE=MyISAM COMMENT='Host privileges; Merged with database privileges';