MySQL Command mode modify MySQL root password note

The process of modifying the MySQL password is as follows

Baidu search an article to see the use of

Format: Mysqladmin-u username-P Old password password new password

I look at the operation when modified

Enter Password:

Welcome to the MySQL Monitor. Commands End With; Or\g.
Your MySQL Connection ID is 10
Server Version:5.5.27-log MySQL Community Server (GPL)

Copyright (c), the Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark the Oracle Corporation and/or its
Affiliates. Names may trademarks of their respective
Owners.

Type ' help, ' or ' \h ' for help. Type ' \c ' to clear the current input statement.

mysql> mysqladmin-u root Password The password I want to set
->
->;
Error 1064 (42000): You have a error in your SQL syntax; Check the manual that
Corresponds to your MySQL server version for the right syntax to use near ' MySQL
admin-u root password The password I want to set ' at line 1
Mysql> mysqladmin-u Root-password I want to set the password
->;
Error 1064 (42000): You have a error in your SQL syntax; Check the manual that
Corresponds to your MySQL server version for the right syntax to use near ' MySQL
Admin-u Root-password I want to set the password ' at line 1

The last small series used mysqladmin-u Root-password I want to set the password can not be fixed, suddenly thought of directly update the table can.

mysql> Update Mysql.user Set Password=password (' I want to set the password ') where user = ' root
';
Query OK, 3 rows affected (0.05 sec)
Rows Matched:3 Changed:3 warnings:0

mysql> flush Privileges;
Query OK, 0 rows affected (0.01 sec)

Mysql>

Okay, that's it. Oh, although the process is not complex and not simple.