Change mysql database password _ MySQL

Modify mysql database password bitsCN.com

How can I reset a password when I forget the password of mysql?

1. use mysqladmin to change the mysql password
C:/> mysqladmin-udbuser-p password newpass
Enter password: oldpass
Of course, the premise of using this command is that you have added mysql to the environment variable. if you have not added the environment variable, you can only cd

The command in the directory where mysqladmin is located!
-----------------------------------------
2. reset the root password
Method 1:
Add the following 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
Mysql> use mysql;
Mysql> update user set password = password ('New password') WHERE User = 'root ';
Mysql> flush privileges;
After running the command, remove skip-grant-tables from my. ini and restart mysqld.
Method 2:
Without modifying my. ini to restart the service, add skip-grant-tables in non-service mode to run mysql to change the mysql password.
Stop mysql service
Open the command line window and start it with mysqld-nt.exe in the bindirectory. that is, execute mysqld-nt -- skip-grant-in the command line window-

Tables
Open a command line window and log on to mysql. you do not need to enter the mysql password.
After changing the password, close the window in which the command line runs mysql. in this case, mysql is closed. if mysql is still running

You can stop the corresponding process.
Start mysql service


Author: xiahuawuyu

BitsCN.com