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

Asked By Ferdous Rider 0 points N/A Posted on - 04/26/2017

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.

Answered By Charles S Rossiter 10 points N/A #295629

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.

Questions
12

Answers
1

Best Answers
0

How To Solve Windows Update Error Code 80244019 Issue?