Reset MySQL Password In Ubuntu

I have forgoten MySQL password on myy ubuntu, then i found this post. it is very helpfull. to reset MySQL password in ubuntu. but you must open two windows termnial, go to terminal, on terminal 1 login as root then stop MySQL service by type :

$ sudo su
$ sudo /etc/init.d/mysql stop

Now go to terminal 2 dont forget login as root then activate MySQL service by type :

$ sudo su
$ sudo mysqld –skip-grant-tables

Back to teminal 1  run MySQL client :

$ myql
$ mysql> use mysql;

Now change password by type query :

$ mysql> update user set Password=password(‘NewPassword’) where User= ‘root’;
$ mysql> flush privileges;

Stop MySQL service on terminal 1 :

$ sudo killall mysqld

Now activate again MySQL service on terminal 1 :

$ /etc/init.d/mysql start

Now you can run new MySQL password.
Sources : http://adhit.web.id/reset-password-root-database-mysql-di-linux/
Happy Testing....!!