Forgot MySQL password reset method under Ubuntu

1. End the currently running MySQL process.

#/etc/init.d/mysql Stop

2. Run in MySQL Safe mode and skip permission verification.
#/usr/bin/mysqld_safe--skip-grant-tables

3. Re-open a terminal to log in to MySQL as root.
# mysql-u Root

4, modify the root user password.
mysql> use MySQL;
Reading table information for completion of table and column names
can turn off this feature to get a quicker startup With-a

Database changed
mysql> Update user Set Password = Password (' root ') where user = ' root ';
Query OK, 3 Rows Affected (0.00 sec)
Rows matched:3 changed:3 warnings:0

mysql> Exit

5. End MySQL Safe mode and run MySQL in normal mode.
#/etc/init.d/mysql Restart

6. Try your newly modified password
 
mysql> Show grants for ' root ' @ ' 127.0.0.1 ';

mysql> flush Privileges;
Mysql> quit

This article is from "peter-unscrupulousness Youth" blog, please be sure to keep this source http://petervip.blog.51cto.com/3790959/1692840

Forgot MySQL password reset method under Ubuntu