1. Error description
C:\USERS\ADMINISTRATOR>D:D:\>CD mysql\program files\mysql\mysql Server 5.6\bind:\mysql\program Files\MySQL\ MySQL Server 5.6\bin>mysqldump--all-databases-uroor-p > All.sqlenter password: **************mysqldump:got erro R:1045:access denied for the user ' roor ' @ ' localhost ' (using password:yes) when trying to connectd:\mysql\program FILES\MYSQ L\mysql Server 5.6\bin>
2. Cause of error
By the explanation of the error, log in to MySQL with the root account, but was rejected.
3. Solutions
Change the root account password
(1) Check MySQL
Use MySQL;
(2) Change root password
Update user set password= ' root ' where user = ' root ';
(3) Refresh the database and restart the service
Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.
Mysqldump:got Error:1045:access denied for the user ' roor ' @ ' localhost ' (using pas sword:yes) when TR