Re: Securing MySQL
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
Subject
Written By
Posted
Re: Securing MySQL
March 17, 2009 11:15AM
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.