Ok.. when you first install MySQL there are those two databases.. mysql.host and test right..
well i deleted mysql.host database
and now it wont start.. i got this from the error file..
this is todays error file..
030922 18:54:38 InnoDB: Flushing modified pages from the buffer pool...
030922 18:54:38 InnoDB: Started
030922 18:54:38 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist
030922 18:54:38 Aborting
030922 18:54:38 InnoDB: Starting shutdown...
030922 18:54:40 InnoDB: Shutdown completed
030922 18:54:40 MySql: Shutdown Complete
030922 19:28:35 InnoDB: Started
030922 19:28:35 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist
030922 19:28:35 Aborting
030922 19:28:35 InnoDB: Starting shutdown...
030922 19:28:37 InnoDB: Shutdown completed
030922 19:28:37 MySql: Shutdown Complete
030922 19:31:12 InnoDB: Started
030922 19:31:12 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist
030922 19:31:12 Aborting
030922 19:31:12 InnoDB: Starting shutdown...
030922 19:31:14 InnoDB: Shutdown completed
030922 19:31:14 MySql: Shutdown Complete
030922 19:31:27 InnoDB: Started
030922 19:31:27 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist
030922 19:31:27 Aborting
030922 19:31:27 InnoDB: Starting shutdown...
030922 19:31:30 InnoDB: Shutdown completed
030922 19:31:30 MySql: Shutdown Complete
030922 19:34:46 InnoDB: Started
030922 19:34:46 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist
030922 19:34:46 Aborting
030922 19:34:46 InnoDB: Starting shutdown...
030922 19:34:48 InnoDB: Shutdown completed
030922 19:34:48 MySql: Shutdown Complete
030922 19:35:25 InnoDB: Started
030922 19:35:25 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist
030922 19:35:25 Aborting
030922 19:35:25 InnoDB: Starting shutdown...
030922 19:35:28 InnoDB: Shutdown completed
030922 19:35:28 MySql: Shutdown Complete
030922 19:35:33 InnoDB: Started
030922 19:35:33 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist
030922 19:35:33 Aborting
030922 19:35:33 InnoDB: Starting shutdown...
030922 19:35:35 InnoDB: Shutdown completed
030922 19:35:35 MySql: Shutdown Complete
030922 19:40:49 InnoDB: Started
030922 19:40:49 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist
030922 19:40:49 Aborting
030922 19:40:49 InnoDB: Starting shutdown...
030922 19:40:52 InnoDB: Shutdown completed
030922 19:40:52 MySql: Shutdown Complete
could anyone give me the SQL for the mysql.host database and see if tat worksa?
