Reset Mysql Root Password

Stop Mysql:
/etc/init.d/mysqld stop

Create a script to run the reset query
vi /root/mysql.reset.sql

add the reset query:
UPDATE mysql.user SET Password=PASSWORD(‘YOUR-NEW-MYSQL-PASSWORD’) WHERE User=’root’;
FLUSH PRIVILEGES;

execute the script:
# mysqld_safe –init-file=/root/mysql.reset.sql &

Sample output:
nohup: ignoring input and redirecting stderr to stdout
Starting mysqld daemon with databases from /var/lib/mysql
mysqld_safe[20970]: started

# killall mysqld
# /etc/init.d/mysql start