Forgot MySQL password resolution

Workaround:

1. Stop the MySQL process

#/etc/init.d/mysql Stop

Post-Execution output:

Stopping MySQL database server:mysqld.

2. Safe mode start MySQL, skip authorization form

# Mysqld_safe--skip-grant-tables &

Post-Execution output:

[1] 5988
Starting mysqld daemon with databases From/var/lib/mysql
MYSQLD_SAFE[6025]: Started

3. New windows open terminal connected to MySQL

# mysql-u Root

4. Reset Password

mysql> use MySQL;
mysql> Update user Set Password=password ("New-root-password") where user= ' ROOT ';
mysql> flush Privileges;
Mysql> quit

5. Stop MySQL Service

#/etc/init.d/mysql Stop

6. Restart MySQL

#/etc/init.d/mysql Start
# mysql-u Root-p

Forgot MySQL password resolution