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.

author: niekto@niekde.sk (Jaroslav Petráš)

date: Wed, 11 Sep 2013 14:25:00 +0000

link: CyberAsylum.eu/sint-change-forgotten-root-password-in-mysql-on-debian-gnu-linux