Mysql forgets the root password and mysql forgets the root password.

Mysql forgets the root password and mysql forgets the root password.
1. stop MYSQL. Open the DOS window in CMD and enter net stop mysql.
2. In the CMD command line window, enter the MYSQL installation directory, for example, E: \ Program Files \ MySQL Server 5.0 \ bin.
Demo command:
Enter e: enter,
Enter cd "E: \ Program Files \ MySQL Server 5.0 \ bin"
Note that double quotation marks must also be entered to enter the Mysql installation directory.
3. Enter the mysql security mode, that is, when mysql is up, it can enter the database without entering the password.

Command: mysqld-nt -- skip-grant-tables

Note: Check the execution program in the MySQL/bindirectory. If some data libraries are mysqld.exe, change them to mysqld -- skip-grant-tables.

4. Open a new CMD command line window, enter mysql-uroot-p, and log on to MySQL using a blank password (Press enter without entering the password)
5. Enter the following command to modify the password of the root user (Note: There is a "point" in the middle of mysql. user ")
Mysql> update mysql. user set password = PASSWORD ('new password') where User = 'root ';
6. Refresh the permission table
Mysql> flush privileges;
7. Exit
Mysql> quit
So MYSQL super Administrator account ROOT has been reset, then in the task manager to end mysqld/mysqld-nt.exe this process, restart MYSQL! (You can also restart the server)
After MYSQL is restarted, you can log on to MYSQL with the newly set ROOT password!
Method 2:

Create pwdhf.txt in the installation directory of MySQL, and enter the text: set password for 'root' @ 'localhost' = PASSWORD ('*****');

The red part shows the new password to be set.
Use windows service management tools or task manager to stop the MySQL service (task manager K drops the mysqld-nt process)
Doscommand prompt to the bin directory under the MySQL installation directory, for example, my directory is D: \ Program Files \ MySQL Server 5.1 \ bin
Then run: mysqld-nt -- init-file = ../pwdhf.txt
After the execution is complete, stop the MySQL database service (Job Manager K drops the mysqld-nt process), and then start MYSQL again in normal mode.
What should I do if I forget the root password in mysql?

Some time ago, when I changed the root password in mysql, I randomly got one, and it was not appropriate. When I came back to use 10.1, I found that I forgot my password and searched it online, the following is a summary: first shut down the mysql service net stop mysql in the command line, and then start it in the command line without checking the permissions; the mysqld -- skip-grant-tables interface will stay there and ignore it. Then open a command prompt window (CMD) and use the empty password to log on to MySQL as the root user; mysql-u root went in directly, and changed the root user password; mysql update mysql. user set password = PASSWORD ('new password') where User = 'root'; mysql flush privileges; mysql quit, press CTRL + ALT + DEL on the keyboard to open the task manager, end the mysql-nt process, shut down the mysql service, restart the mysql service, and re-open the command line interface, mysql-uroot-p, and enter your new password; the above is the password cracking method for mysql in windows. Next I will talk about etc/my in mysql in linux. add the [mysqld] field of cnf: skip-grant-tables to restart the mysql service. In this case, mysql can log on to the database without a password and then enter mysqlmysqluse mysql; mysqlupdate user set password = password ('new password') WHERE User = 'root'; after running, remove etc/my. skip-grant-tables in cnf. Restart mysqld.

What if I forget the root password of MySql? How can I retrieve my password? How can I change the root password? Thanks

For the root password:

Method 1:
MySQL provides command line parameters for skipping access control and starts the MySQL server by running the following command:
Safe_mysqld -- skip-grant-tables &
You can skip MySQL Access Control. Anyone can enter the MySQL database as an administrator on the console.
It should be noted that after the password is changed, the MySQL server should be stopped and restarted to take effect.
First find mysql. server and then stop mysql Service
# Mysqld_safe -- skip-grant-tables -- skip-networking &
# Mysql
> Use mysql;
> Update user set password = PASSWORD ("new-password") where user = "root ";
> Flush privileges;

Method 2:
Follow these steps to reset the MySQL root Password:
1. First confirm that the server is in a secure state, that is, no one can connect to the MySQL database at will.
Because, during the resetting of the MySQL root Password, the MySQL database is completely out of password-free
Other users can log on to and modify MySQL information as needed. You can use
The external port is closed, and Apache and all user processes are stopped to implement server quasi-security.
Status. The safest status is to operate on the server Console and unplug the network cable.
2. Modify MySQL Logon Settings:
# Vi/etc/my. cnf
In the [mysqld] section, add skip-grant-tables.
For example:
[Mysqld]
Datadir =/var/lib/mysql
Socket =/var/lib/mysql. sock
Skip-name-resolve
Skip-grant-tables
Save and exit vi.
3. Restart mysqld
#/Etc/init. d/mysqld restart
Stopping MySQL: [OK]
Starting MySQL: [OK]
4. log on to and modify the MySQL root Password
#/Usr/bin/mysql
Welcome to the MySQL monitor. Commands end with; or \ g.
Your MySQL connection id is 3 to server version: 3.23.56
Type 'help; 'or' \ H' for help. Type '\ C' to clear the buffer.
Mysql> USE mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with-
Database changed
Mysql> UPDATE user SET Password = password ('new-password') WHERE User = 'root ';
Query OK, 0 rows affected (0.00 sec)
Rows matched: 2 Changed: 0 Wa... the remaining full text>