04
Dec
Fix errors on Windows 2003 with MySQL 5.0+
Filed Under (Windows) on 04-12-2007
The error “Fatal error: Can’t open and lock privilege tables: Table ‘mysql.servers’ doesn’t exist” is caused by some incomplete privilege tables. Please run the following command at a command prompt:
# cd "Program FilesMySQLMySQL Server 5.2scripts"
# mysql --force -uroot -p mysql < mysql_fix_privilege_tables.sql
This did the trick for me - not too sure why this wasn’t part of the install but all is well now.
