How To Solve Error 1045 28000 Access Denied For User Manually?

Asked By 0 points N/A Posted on -
qa-featured

I am working on a database using MySQL. While trying to connect to the database, I am getting error 1045 28000 access denied for user.

I am not using any password for the same. Still, I am getting such kind of problems.

I am new to MySQL. Please tell me what to do. Thank you in advance.

Image result for error 1045 28000 access denied for user
SHARE
Answered By 10 points N/A #295629

How To Solve Error 1045 28000 Access Denied For User Manually?

qa-featured

I was having a similar problem which did not appear after I performed this solution.

You will have to reset your password.

First, start MySQL server instance with the option “–skip-grant-tables.”

Then,execute the statements given below.

# mysql -u root mysql

Next,

mysql> UPDATE root SET Password=’your_new_password’;

Then,

mysql> FLUSH PRIVILEGES;

Now, restart the daemon/instance without the option “–skip-grant-tables.”

You will now be able to connect using your new password.

Hope this will help you.

Login/Register to Answer

Related Questions