Changing the password of a user in MySQL

Steps to restore a user password in mysql included for root:

1. mysql -u root

2. update user set password=PASSWORD("qwertyqwerty") where user="jordi";

3. flush privileges;

SOURCE:http://systemadmin.es/2011/10/cambiar-contrasena-usuario-mysql