reset mysql password

just a short memo, as usual:

stop mysql

restart in safe mode:

mysqld_safe --skip-grant-tables &

enter as root, now:

mysql -u root

and reset table password:

use mysql
update user set password=PASSWORD('newpassword') where user='root';