MySQL Change password

1. Mysql>access denied for user ' root ' @ ' localhost ' (using Password:yes) appears
Or mysql>access denied for user ' root ' @ ' localhost ' (using Password:no)
Both of these phenomena (1045 errors)

Check to see if the MySQL service can be turned on to ensure that the MySQL service is up and running.

Step one: Unzip your MySQL to the C packing directory
The second step: after extracting into the directory, find the Install.bat file, open with Ediplus, find--install MySQL and net start MySQL, two MySQL must be the same
Step three: Enter the cmd command (without configuring the environment variable to manually switch to the Mysql\bin directory under the CD command entry)
Fourth step: Log in to MySQL (mysql-localhost-u root) without setting the MySQL password at this time
Fifth step: Select MySQL library after successful login
Mysql>use MySQL; #选择mysql数据库
Mysql>update user SET Password=password (' NewPassword ') where user= ' root ';
Myqsl> Prompt Success
Mysql>flush privileges;
Mysql> Prompt Success
Mysql>quit (launched)

New Login MySQL
Mysql>mysql-h localhost-u root-p (need to enter password)
mysql> Prompt to enter password (' root ')
Enter Password to modify success

MySQL Change password