Home > Windows > Fix errors on Windows 2003 with MySQL 5.0+

Fix errors on Windows 2003 with MySQL 5.0+

December 4th, 2007 Leave a comment Go to comments

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.

Categories: Windows Tags:
  1. No comments yet.
  1. No trackbacks yet.