1067 error on attempt to start MySQL

Question

I've installed MySQL on Windows 7. When I'm trying to start MySQL service I'm getting error 1067: The process terminated unexpectedly. Log message:

101111 22:27:11 [Note] Plugin 'FEDERATED' is disabled. C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Table 'mysql.plugin' doesn't exist 101111 22:27:11 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. InnoDB: Log scan progressed past the checkpoint lsn 0 37356 101111 22:27:11  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: Doing recovery: scanned up to log sequence number 0 44233 101111 22:27:11  InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percents: 86 87 88 89 90 91 92 93 94 95 96 97 98 99  InnoDB: Apply batch completed 101111 22:27:12  InnoDB: Started; log sequence number 0 44233 101111 22:27:12 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist 

What can I do about it?

Answer 1

The solution was to install MySQL without spaces in installation path. Windows 7, 64-bit

Answer 2

One more thing that prevents the mysqld windows service from running is if you have mysqld.exe already running (but not as a service) and occupying port 3306. When the service tries to start and sees that port 3306 is already taken, it fails.

Just open up the windows task manager and look for "mysqld.exe" under the Processes tab. If you see it, kill it and then try to start the service again.

c:\> net start [servicename] 

example: c:\> net start MySQL