I was playing with the users table in mysql database. Not sure what I did, but now, I cant see any of my databases in there when I log in with Root user. I know I have not deleted them, and they still exist in my computer, but I guess I do not have permission to view them.

From command prompt, when I go to >mysql and try to add a user by:

mysql> grant all privileges on *.* to abc@localhost identified by 'abc';
ERROR 1045: Access denied for user: '@localhost' (Using password: NO)


Looks like I do not have access enough to do that. Can someone please write me, how to go about getting my permissions back?

Thanks a lot!

Look at: " identified by 'abc';" and "Using password: NO"

It seems you try connect without password.