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
Thanks for reading this post………………………………..!!!