Password reset in MySQL طباعة

For root password reseting of MySQL data bases connect to server via SSH (we recommend use SSH client - Putty)

Than sop MySQL :
# service mysql stop (service will be named - mysqld)

Start MySQL with specific rules:
# mysqld_safe --skip-grant-tables &

root
# mysql -u root

Further need to execute SQL request to change password for root:
# update user set password=PASSWORD("newpassword") where User='root';
where newpassword – is a new password

Apply your changes :
# FLUSH PRIVILEGES;

Now you can leave from MySQL client by using command “exit” and restart MySQL server:
# service mysql restart