1

This may be a noob question.

But I have tried everything, purging and reinstalling trying to reconfigure and the works.

For some reason my root that was set without a password on localhost is denying me access

I have tried to reset the root password using the command line but to no avail.

Does anybody know how to get this error to be fixed?

ERROR 1045 (28000): Access denied for user 'devin'@'localhost' (using password: NO)

I am using linux and ubuntu

Improve this question
0

1 Answer 1

Reset to default
0

Even though you set your root user to login without a password, this does not mean that user devin has been configured to login without a password.

Edit your .my.cnf file:

vi ~/.my.cnf

In the file which you see, hard code the password for user devin, save the file, then exit.

[client]
user=devin
password=your_password_goes_here

Then restart MySQL and devin should be able to login without using a password.

The following command should work to connect you to a database called my_db:

mysql --user=devin my_db
Improve this answer
Sign up to request clarification or add additional context in comments.

6 Comments

Perhaps I have done it wrong, but I still get an error after this ERROR 1045 (28000): Access denied for user 'devin'@'localhost' (using password: YES) The only difference now is that it says using password: YES
Are you sure you have the right password? Can you connect from the command line?
This is the error from the command line, It is wierd that it does not connect
It isn't weird if you are using the wrong password. Are you certain that the credentials are correct? Have you ever been able to login?
Yes, I did a fresh install just before posting to make sure they were right, I have also tried a number of my most common passwords
|

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.