MySQL Tip: 1045 Access denied for user ' root ' @ ' localhost ' using password Yes

1. Open DOS to enter MySQL under the bin directory (C:\Program files\mysql\mysql Server 5.6\bin)

2. Stop MySQL service, net stop MySQL

3. Input: mysqld--defaults-file= "C:\Program files\mysql\mysql Server 5.6\my-default.ini"--console--skip-grant-tables

4. Reopen a DOS window, enter MySQL under the bin directory, enter: Mysql-root-p

5. Prompt for password, enter password after enter, enter mysql>

6. Enter update (database name) set Password=password (' NewPassword ') where user= ' root '

7. Enter the flush privileges;

8. Enter quit

Ok!!!!!!!!!

MySQL Tip: 1045 Access denied for user ' root ' @ ' localhost ' using password Yes