This little snippet helps to reset mysql root password

reset_db_password.sh

$ ps -ax

$ #Kill all the related mysql process and direct run the next lines#

$ sudo /usr/local/mysql/bin/mysqld_safe --user=mysql --skip-grant-tables --skip-networking &

#direct log after execute bellow command#
$ mysql -u root

mysql > database mysql;

mysql > UPDATE mysql.user SET password=PASSWORD('nouveau') WHERE user='root';

# you are now happy :)