We have MySQL setup as a MYSQL_MULTI configuration so that each
database has their own instance of MySQL. We need another database configured and so added an entry in the my.cnf. We've tried to start the new database, but keep getting this error. We know that for each database there needs to be a mysql sub-folder to store the tables that store grants and such, but how to we get those created for the new instance. We've been all over the MySQL.com docs and can't find the solution. Anyone have any ideas? Thanks 050423 12:07:20 mysqld started 050423 12:07:20 [Warning] Asked for 196608 thread stack, but got 126976 050423 12:07:20 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 050423 12:07:20 InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 43634. InnoDB: Doing recovery: scanned up to log sequence number 0 43634 050423 12:07:20 InnoDB: Flushing modified pages from the buffer pool... 050423 12:07:20 InnoDB: Started; log sequence number 0 43634 050423 12:07:20 [ERROR] Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 050423 12:07:20 mysqld ended --
|
<<inline: logo_webimpact.gif>>