MYSQL root password modification command summary _ MySQL

MYSQL root password modification command summary bitsCN.com 1. how can I change the root administrator password of mysql at the win2K command prompt?

> Mysql-u root-p
Enter password :******
Mysql> use mysql;
Mysql> update user set password = password ('New _ password') where user = 'root ';

In this way, you can directly change the password. If you can log on to MySQL under CMD, add "C:/Program Files/MySQL Server 5.0/bin" to the PATH of the Windows environment variable; "(change to your own installation path.

II. MYSQL root password command

Switch to the mysql installation directory under cmd
Example
D:/mysql/bin
Prerequisites: the mysql root password is empty.
Enter mysql-u root mysql
Mysql> enter update user set password = password ('New password') where user = 'root ';
Echo
Query OK, 0 rows affected (0.00 sec)
Rows matched: 2 Changed: 0 Warnings: 0
Mysql> status, enter flush privileges;
Echo
Query OK, 0 rows affected (0.00 sec)
Mysql> Enter quit
Exit SQL

Note that a semicolon ";" must be added after each command ";"
Mysql started to execute this command
The second command updates the database of the mysql system that has been loaded into the memory.

Restart mysql.
Stop MYSQL
Net stop mysql
Start MYSQL
Net start mysqlbitsCN.com