Reset MySQL root password.

1. Reset the password for mysql root user to 'linux123'.

service mysqld stop
mysqld_safe --skip-grant-tables &
mysql -u root
update mysql.user set password=PASSWORD("linux123") where User='root';
flush privileges;
exit;
service mysqld stop
service mysqld start

2. Make sure you login directly to the mysql console by typing in 'mysql' in konsole.

create a file "  /root/.my.cnf "
[client]
user="root'
password="linux123"

3. Find a way to backup all database in the server at once.

./mysqldump --all-databases > /root/backup/all.sql