ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)

ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)

Root cause: Root cause for the above error may be password you are entering may be wrong.

Reset your xampp mysql root password in windows:

Step 1: Open the xampp control panel and “stop the mysql service”.

Step 2: Create a text file named mysql-init.txt and paste the below code,

UPDATE mysql.(dot is mandatory dont forget)user SET Password=PASSWORD(‘javadomain’) WHERE User=’root’;FLUSH PRIVILEGES;

here javadomain is the new password setting for root.

Step 3: Open the command prompt and run the below command to reset the password for the root.

C:\> C:\mysql\bin\mysqld.exe –init-file=C:\\mysql-init.txt

mysql password reset

Thanks for reading this post………………………………..!!!




1,017 total views, 2 views today

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.