Operating system: windows8.1, previously installed MySQL, this installation in the last part of the configuration to perform "Apply security settings" The process of pop-up classic error:
Access denied for user ' root ' @ ' localhost ' (using Password:yes)
Online search for a variety of methods, there are: the original MySQL did not uninstall the complete, failure, there are changes to the password, the solution is as follows:
The workaround is to reset the root user password by following the steps in the Windows platform:
1. Log in to the system as a system administrator;
2. If the MySQL server is running, stop it.
If the server is running as a Windows service, go to Service Manager: Start menu, Control Panel, management tools, services
If the server is not running as a service, you might need to use Task Manager to force it to stop.
3. Create 1 text files and place the following commands in a single line:
SET PASSWORD for ' root ' @ ' localhost ' = PASSWORD (' Mynewpassword ');
Save the file with any name. In this case, the file is F:\mysql-init.txt.
4. Enter DOS command prompt: Start menu, run-cmd
Assume that you have installed MySQL to F:\Program Files\mysql. If you installed MySQL in a different location, please adjust the following commands accordingly.
At the DOS command prompt, go to the MySQL folder and execute the command:
F:
CD F:\Program files\mysql\mysql Server 5.1\bin
F:\Program files\mysql\mysql Server 5.1\bin>mysqld-nt--init-file=f:\mysql-init.txt
When the server starts, change the root user password by executing the contents of the file named by the "--init-file" option (function: Read the SQL command from the specified file at startup). When the server starts successfully, you should remove C:mysql-init.txt.
5. Restart the MySQL service.
Do not say, success.
A resolution case where MySQL installation fails under Windows