An Heng network manager's note: Forgotten mysql password change _ MySQL

An Heng network manager's note: A Hacker who forgets the mysql password

If MySQL is running, killall-TERM mysqld is first killed.

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

You can access MySQL without a password.

Then

> Use mysql
> Update user set password = password ("new_pass") where user = "root ";
> Flush privileges;

Kill MySQL again and start MySQL in a normal way.

The safe_mysqld of Redhat is in/usr/bin, and the tarball is installed in/usr/local/bin by default.