Recover lost root password in mysql
-----------------------------------
login as unix root 
stop mysqld (/etc/init.d/mysqld stop) 
start mysqld (/usr/bin/safe_mysqld --skip-grant-tables) 
login into the mysql server (mysql -u root mysql) 
change the root password (update user set password=password('new_password') where user='root';) 
flush the privileges for the change to take effect (flush privileges;) 
exit the database (quit) 
stop the database (might need to kill the process) 
restart the database as normal (/etc/init.d/mysqld start)