#1045-Access denied for user 'root' @ 'localhost' (using password: YES)
Operating System: windows xp
Problem description:
You have modified the root password in the console shell and cannot log on to the console at http: // localhost/phpmyadmin.
Error: #1045-Access denied for user 'root' @ 'localhost' (using password: YES)
Operation reproduction:
Mysql-u root-p
* ***** # Previous password
Use mysql;
Update user set password = PASSWORD ('new _ passwd') where user = 'root'; # set your new password
Flush privileges;
Then you cannot log on to phpmyadmin.
Cause:
This is because the original password is not changed in the phpmyadmin configuration file, so the login fails.
Solution:
Find your XAMPP storage directory: My: F:/xampp/phpMyAdmin/config. inc. php
Modify the red mark, which should be your previous password, change it to your new password, and then access it again.