MySQL Forums
Forum List  »  Newbie

Re: Securing MySQL
Posted by: Robert Williams
Date: March 17, 2009 11:15AM

Rick:

Thanks for the response. I did not find a mysqld.err log file, but one named [machinename].err in the InnoDB data directory. The error messages produced from the service startup failure are listed below:

E:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Table 'mysql.plugin' doesn't exist
090313 11:38:57 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
090313 11:38:57 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...
090313 11:38:58 InnoDB: Started; log sequence number 0 46604
090313 11:38:58 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist

I've tried running mysql_upgrade as suggested, but to no avail. Now I've run into the problem that I can't start the service under Local Service either. So, I may need to uninstall/reinstall to reset the configuration before continuing debugging. But if the errors above suggest anything to you, I'd appreciate hearing any hunches/knowledge you can share.

--Robert

Options: ReplyQuote


Subject
Written By
Posted
March 12, 2009 08:16PM
March 13, 2009 10:59AM
March 13, 2009 08:12PM
Re: Securing MySQL
March 17, 2009 11:15AM
March 17, 2009 11:42AM


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.