N/APosted 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.
How To Solve Error 1045 28000 Access Denied For User Manually?
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
mysql> UPDATE root SET Password=’your_new_password’;
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.