SINT - Change forgotten MySQL root password on Debian GNU/Linux

Log-in as MySQL user debian-sys-maint.
We can find its credentials in /etc/mysql/debian.cnf

mysql -u debian-sys-maint -p

And use following queries

 
UPDATE `mysql`.`user` set password=PASSWORD("qWaqSY7fRKB6YWu2iUgwz2Gy") where `user`='root';
FLUSH PRIVILEGES;
 

Finaly, test your new password

mysql -u root -p

Note: password in this article was generated only for this article purposes.
Note: You can change password for any user in this way.