MySQL Modify Administrator account password

Error message: Error 1045 (28000): Access denied for user ' root ' @ ' localhost ' (using Password:yes)
MySQL Agent error message: Error (HY000): Lost connection to MySQL Server at ' reading authorization packet ', System error:0
Change Password:
Prerequisite: The password of the root account should be known.

Login Root:

Execute the statement;

mysql> Update mysql.user set Password=password (' Letmein ') where user= ' root '

Mysql> FLUSH Privileges
Mysql> exit
Note: The key must be refreshed here.

Many times it is very easy to change the password, but when with other projects jumbled together error, often do not know how to deal with,

Mysql-u root-pletmein-h 127.0.0.1-p 3307 Login unsuccessful

Change to: Mysql-u root-pletmein-h 127.0.0.1-p 3307 or login unsuccessful

Change: Mysql-u root-p-H 127.0.0.1-p 3307 Login Successful

====> concludes that the MySQL password is null

====> then learned to change the password

MySQL Modify Administrator account password