Access denied for user ''@'localhost' (using password: NO) in mysql

Question

I have been used following command but it was not working.

GRANT ALL PRIVILEGES ON *.* TO ROOT@LOCALHOST IDENTIFIED BY "my_password";

possible useful if you are locked out of your database: http://stackoverflow.com/questions/1708409/how-to-start-mysql-with-skip-grant-tables — Paul, Aug 11 '13 at 10:19

score 1 · Answer 1 · answered Aug 11 '13 at 10:22

1

You are not connected (in the way of a login & username) to the database, you need to connect. depending on the way you acces the database. in command line, you can use this:

mysql -pYourpassword -u username

answered Aug 11 '13 at 10:22

Vincent Duprez

3,772
8
36
76

now Access denied for user 'root'@'localhost' (using password: YES – parmeshawar Aug 11 '13 at 10:27
probably wrong password, have you been able to connect to your db in the past? – Vincent Duprez Aug 11 '13 at 10:30
yes! i was granting and revoking privileges last day when got problem even i reset password as well as i searched lot on net. – parmeshawar Aug 11 '13 at 10:35
1

Thats the hard way and will let you make a new password, if this is not a production base, then it could easily solve the problem. Let us know – Vincent Duprez Aug 11 '13 at 10:44

Access denied for user ''@'localhost' (using password: NO) in mysql

1 Answers1