Windows (Mysql) Access denied for user ' root ' @ ' localhost ' (using password:yes) solution

Solution: 1. Add a line "Skip-grant-tables" at the end of the My.ini file to save and close the file. 2. Restart the MySQL service. 3, enter "Mysql-uroot-p" in the command line (do not enter a password), enter the database. 4, execute, "use MySQL;" Use the MySQL database. 5. Execute, "Update user set Password=password (" New password set by yourself ") where user= ' root '; (change root password)6, open the My.ini file, delete "Skip-grant-tables", save and close the file. 7. Restart the MySQL service. 8, enter "Mysql-uroot-prootadmin" in the command line, the problem is done! proven , successful solution

Windows (Mysql) Access denied for user ' root ' @ ' localhost ' (using password:yes) solution