centos reset mysql root password
sudo /etc/init.d/mysqld stop
sudo mysqld_safe --skip-grant-tables &
mysql -u root
use mysql;
update user set password=PASSWORD("newrootpassword") where User='root';
flush privileges;
quit
sudo /etc/init.d/mysqld stop
sudo /etc/init.d/mysqld start
http://www.rackspace.com/knowledge_center/article/mysql-resetting-a-lost-mysql-root-password
