Yesterday reinstall the next system, after installing MySQL, installed a client tool to connect to MySQL, prompting access denied for user ' root ' @ ' localhost ' (using Password:yes)
Find some solutions on the Internet, all of them are solutions under the Linux system confused.
Here's how Windows solves
1. Admin login system, stop MySQL service or end mysqld-nt process
2. Go to the command line and come to the MySQL installation directory. Assuming that the installation directory is C:\Program Files (x86) \mysql\mysql Server 5.1\bin, cmd goes to the command line
3. Run C:\Program files (x86) \mysql\mysql Server 5.1\bin\mysqld--defaults-file= "C:\Program files (x86) \mysql\mysql Server 5.1\my.ini "--console--skip-grant-tables
4. Open a DOS window again, and cut to the MySQL bin directory,
C:\Program Files (x86) \mysql\mysql Server 5.1\bin\>mysql-uroot MySQL
5. Change root password, mysqladmin-u root flush-privileges password "NewPassword"
6. Restart the MySQL service
MySQL error:access denied for user ' root ' @ ' localhost ' (using Password:yes)