Retrieve the mysql root password _ MySQL

Retrieve the mysql root password bitsCN.com

I set the root password for mysql I just installed yesterday. today I cannot get in.
I used a common solution. As follows:
1. send the kill command to the mysqld server to disable the mysqld server (not kill-9). the files that store the process ID are usually located in the directory of the mysql database.
# Killall-TERM mysqld
2. use the '-- skip-grant-tables' parameter to start mysqld.
#/Usr/bin/mysqld_safe -- skip-grant-tables
3. log on to the mysqld server without a password,
> Use mysql
> Update user set password = password ("new_pass") where user = "root ";
> Flush privileges;
You can also do this: 'mysqladmin-h hostname-u user password' new password ''.

4. # killall-TERM mysqld
5. log in with the new password

BitsCN.com