Mysqldump: Got error: 1045: Access denied for user 'roor' @ 'localhost' (using pas sword: YES) when tr,
1. Error description
C: \ Users \ Administrator> d: D: \> cd MySQL \ Program Files \ MySQL Server 5.6 \ binD: \ MySQL \ Program Files \ MySQL Server 5.6 \ bin> mysqldump -- all-databases-uroor-p> all. sqlEnter password: *************** mysqldump: Got error: 1045: Access denied for user 'roor' @ 'localhost' (using password: YES) when trying to connectD: \ MySQL \ Program Files \ MySQL Server 5.6 \ bin>
2. Error cause
According to the error message, you can log on to mysql with the root account but are denied.
3. Solution
Modify the root account password
(1) select mysql
Use mysql;
(2) modify the root password
Update user set password = 'root' where user = 'root ';
(3) refresh the database and restart the service
Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.