How to remember the MySQL password

This article will explain in detail how to remember the MySQL password, the content of the article is of high quality, so the editor will share it for you as a reference. I hope you will have a certain understanding of the relevant knowledge after reading this article.

Under windows:

Open a command line window and stop the mysql service: Net stop mysql

Start mysql in the installation path to mysql, start using mysqld-nt.exe in the bin directory, and execute: mysqld-nt-- skip-grant-tables in the command line window

Then open a separate command line window and execute mysql, which allows you to enter without entering a password.

> use mysql

> update user set password=password ("new_pass") where user= "root"

> flush privileges

> exit

Use the Task Manager to find the mysqld-nt process and end the process!

After restarting the mysql-nt service, you can log in with the new password.

Under linux:

If MySQL is running, kill it first: killall-TERM mysqld.

Start MySQL: bin/safe_mysqld-- skip-grant-tables &

You can enter MySQL without a password.

And then there is.

> use mysql

> update user set password=password ("new_pass") where user= "root"

> flush privileges

Kill MySQL again and start MySQL in the normal way.

About how to share the MySQL password memo here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.