mysql server root password recovery

Stop MySQL

# sudo /etc/init.d/mysqld stop

start mysql in Safe mode

# mysqld_safe --skip-grant-tables &

Login as root

# mysql -uroot

Reset Password

# use mysql;
mysql> update user set password=PASSWORD("mynewpassword") where User='root';
mysql> flush privileges;
mysql> quit

Restart

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

start and stop commands may vary depending on Linux distro