MySQL Forums
Forum List  »  Install & Repo

Re: Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
Posted by: marko.skarica
Date: April 05, 2006 04:24PM

I installed mysql on Solaris 9 (64 bit), and I'm getting the same exact problem. I've searched all over, tried several things recommended by others, but nothing is doing the trick. I am able to run the "mysql.server start" command as root and the server starts (even though I definitely used the --user=mysql parameter when I called the scripts/install_db_tables script), but when running the "bin/mysqld_safe --user=mysql" command to start the database, I get the error everyone else is getting.

mysqld started
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...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 .
InnoDB: Doing recovery: scanned up to log sequence number 0 43655
InnoDB: [ERROR] Fatal error: Can't open and lock priviledge tables: Table 'mysql.host' doesn't exist
mysql ended

Please help, I've spent days on this, I don't even know where to look next.

Options: ReplyQuote


Subject
Written By
Posted
Re: Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
April 05, 2006 04:24PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.