MySQL Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist

by Waqas 8/17/2008 9:27:00 PM

This means that mysql cannot find the table it uses to store usernames. It may be corrupt or deleted. 

To resolve it;

Goto mysql data folder e.g. D:\wamp\bin\mysql\mysql5.0.51a\data\mysql and make sure you have these three files user.frm user.MYI AND user.MYD 

if they are missing you can download them from here and replace all 3 files.

Restart wamp and your icon should go white :)

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags:

Tips n Tricks

Related posts

Add comment


(Will show your Gravatar icon)  

  Country flag

biuquote
  • Comment
  • Preview
Loading




Tags

© Copyright Beyond Web Logs.


Recent comments

Disclaimer

The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.

© Copyright 2008

Sign in