How to solve the problem of MySQL forgetting the superuser password

Solution for MySQL to forget the superuser password if MySQL is running, killall-TERMmysqld is first killed. Start MySQL: binsafe_mysqld -- skip-grant-tables to enter MySQL without a password. Fromwww.w3sky.com and then usemysqlupdateusersetpasswordpassword (

Solution for MySQL to forget the superuser password if MySQL is running, killall-TERM mysqld is first killed. Start MySQL: bin/safe_mysqld -- skip-grant-tables to enter MySQL without a password. // From www.w3sky.com and then use mysql update user set password = password ("

How to solve the problem of MySQL forgetting the superuser password

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

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

You can access MySQL without a password. // From www.w3sky.com

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.