Mysqldump: Got error: 1045: Access denied for user & #39; roor & #39; @ & #39; localhost & #39; (using pas sword: YES) when tr,

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.