How to reset mysql root password ?

1. Stop/ kill the mysqld
# service mysql stop
#pkill -9 mysqld

2) Start the mysql insafe mode as follows

# /usr/sbin/mysqld --skip-grant-tables --user=root &

3) Now update the mysql user tables and root password as follows

#mysql
mysql>use mysql;
mysql>UPDATE user SET Password=PASSWORD('YOUR_PASSWORD') WHERE Host='localhost' AND User='root';
mysql>flush privileges;

Now add the new password “YOUR_PASSWORD” in /root/.my.cnf and start mysql

# service mysql start


// To grant privilege on mysql table

grant EXECUTE on procedure lenbelle_mydbr.sp_MyDBR_UserPassword to 'lenbelle_mydbru'@'localhost';

where lenbelle_mydbr.sp_MyDBR_UserPassword = procedure that having problem
lenbelle_mydbru = dbuser