Change Mysql Password in Ubuntu (Forget Password)

Version:
Ubuntu: 14
MySQL: 5.5


1.Change the MYSQL Parameter:
sudo vi /etc/mysql/my.cnf

32 #
33 # * Basic Settings
34 #
35 user = mysql
36 pid-file = /var/run/mysqld/mysqld.pid
37 socket = /var/run/mysqld/mysqld.sock
38 port = 3306
39 basedir = /usr
40 datadir = /var/lib/mysql
41 tmpdir = /tmp
42 lc-messages-dir = /usr/share/mysql
43 skip-external-locking

Add "skip-grant-tables"


32 #
33 # * Basic Settings
34 #
35 user = mysql
36 pid-file = /var/run/mysqld/mysqld.pid
37 socket = /var/run/mysqld/mysqld.sock
38 port = 3306
39 basedir = /usr
40 datadir = /var/lib/mysql
41 tmpdir = /tmp
42 lc-messages-dir = /usr/share/mysql
43 skip-external-locking
44 skip-grant-tables


2.Restart mysql:
sudo service mysql restart


3.Change mysql Password:

use mysql
describe user;
select host, user, password from user;
update user set password = PASSWORD("new_password") where user = 'root';
select host, user, password from user;
quit


4.Restart mysql:
sudo service mysql restart


5.Enter to Mysql by New Password:
mysql -uroot -pnew_password