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



--
Don Vaillancourt
Director of Software Development
WEB IMPACT INC.
phone: 416-815-2000 ext. 245
fax: 416-815-2001
email: [EMAIL PROTECTED]
web: http://www.web-impact.com
address: http://www.mapquest.ca
Web Impact Inc.
This email message is intended only for the addressee(s) and contains information that may be confidential and/or copyright.

If you are not the intended recipient please notify the sender by reply email and immediately delete this email.

Use, disclosure or reproduction of this email by anyone other than the intended recipient(s) is strictly prohibited. No representation is made that this email or any attachments are free of viruses. Virus scanning is recommended and is the responsibility of the recipient.

<<inline: logo_webimpact.gif>>

Reply via email to