MySQL reset root password
You forgot your mysql root password? No problem, if you are root on the system ...:
#stop running mysql daemon
service mysqld stop
#start mysqld without user access checks
mysqld_safe --skip-grant-tables &
#connect to mysqld
mysql
use mysql;
UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root';
FLUSH PRIVILEGES;
exit;
#stop mysqld without user access checks
service mysqld stop
#start mysqld "the normal way"
service mysqld start
