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: stackoverflow.com/questions/1708409/… — Paul
– Paul, Commented Aug 11, 2013 at 10:19

Vincent Duprez · Accepted Answer · 2013-08-11 10:22:11Z

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, 2013 at 10:22

Vincent Duprez

3,9309 gold badges40 silver badges81 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

parmeshawar Over a year ago

now Access denied for user 'root'@'localhost' (using password: YES

Vincent Duprez Over a year ago

probably wrong password, have you been able to connect to your db in the past?

parmeshawar Over a year ago

yes! i was granting and revoking privileges last day when got problem even i reset password as well as i searched lot on net.

Vincent Duprez Over a year ago

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

Collectives™ on Stack Overflow

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

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related