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";

Answer 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