How to change the user password in mysql and how to forget the password in mysql _ MySQL

How mysql modifies user passwords and how mysql forgets passwords bitsCN.com

Change password:

// Select a database
Use mysql;
// Change the password
Update user set password = password ('New password') where user = 'root ';
// Takes effect immediately
Flush privileges

Forget the administrator password:

Add the following content to the [mysqld] field of my. ini:

Skip-grant-tables

Restart the mysql service. mysql can log on to the database without a password.
Then go to mysql

Use mysql; update user set password = password ('New password') where user = 'root ';
Flush privileges

After running the command, remove the skip-grant-tables in my. ini and restart mysql.

BitsCN.com