How to reset passwords (Root and Users) for MySQL

README.md

How to reset passwords (Root and Users) for MySQL

$ sudo su

$ /etc/init.d/mysql stop
$ mysqld_safe --skip-grant-tables &
$ mysql -u root

mysql> update user set password=PASSWORD("tmprootpwd") where user='root';
mysql> flush privileges;
mysql> quit

$ /etc/init.d/mysql stop
$ /etc/init.d/mysql start

$ mysql --user=root --password=tmprootpwd

mysql> SET PASSWORD = PASSWORD('myFuckingPwdForRoot');
mysql> SET PASSWORD FOR 'myUser'@'%' = PASSWORD('myFuckingPwdForMyUser');