Bug #38478 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' do
Submitted: 31 Jul 2008 6:56 Modified: 1 Aug 2008 4:58
Reporter: Tomas Dalebjörk Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Config Wizard Severity:S3 (Non-critical)
Version:5.0 OS:Windows
Assigned to: CPU Architecture:Any
Tags: Apply Security Settings Fail, reisnstall

[31 Jul 2008 6:56] Tomas Dalebjörk
Description:
Hi,
I started the Windows Config Wizard:
C:\Program Files\MySQL\MySQL Server 5.0\bin>MySQLInstanceConfig.exe
And removed the instance
And to be sure, removed all files under:
C:\Program Files\MySQL\MySQL Server 5.0\data\> del *

Running the Windows Config Wizard again:
C:\Program Files\MySQL\MySQL Server 5.0\bin>MySQLInstanceConfig.exe
And install the Instance again

But the wizard failes when "Apply security settings"
Error Nr. 2003

And reading the:
C:\Program Files\MySQL\MySQL Server 5.0\data\segotwd9524.err
gives ...
080731  8:50:54  InnoDB: Started; log sequence number 0 0
080731  8:50:54 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist

Please suggest what to do next.

How to repeat:
Running the Wizard again
[31 Jul 2008 6:57] Tomas Dalebjörk
mysql server error log

Attachment: segotwd9524.err (application/octet-stream, text), 980 bytes.

[31 Jul 2008 8:02] Tomas Dalebjörk
can this be a firewall issue?
I will try to add this program to the list, but it is currently greyed out.
[31 Jul 2008 12:20] Susanne Ebrecht
Many thanks to write a bug report.

This don't look like a firewall problem.

It more looks like something goes wrong during your mysql re-installation.

You can do two things:

1.1 Remove all MySQL stuff again including the my.ini or my.cnf files.
1.2 Re-Install again

2.1 remove the mysql data dir
2.2 run the bin/mysql_install_db script manually

This will create a new data dir. Please make sure that it makes no errors.

2.3 look if you have no a mysql directory in your data dir

if not, then please look into your configuration file (my.cnf or my.ini) ... Look if you have more as one of this on your system (in different directories)

Remove them all and try it again.

Please let us know, if this will solve your problems.
[1 Aug 2008 4:58] Tomas Dalebjörk
Thanks,
The solution solved my problem
Regards Tomas