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.

No Comments
Read More
19

Jun

Disabling performance counters (Windows)

Filed Under (Windows) on 19-06-2007

  1. Backup your registry
  2. Open “regedit”
  3. Navigate to “HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services”
  4. Find the service you wish to disable performance counters for
  5. Navigate the performance key. If the key does not exist, create it.
  6. Create a DWORD entry called “Disable Performance Counters” and set the value to 1
  7. Enjoy a cool beverage.
No Comments
Read More