The commands below will help you reset any mysql user password.
use mysql;
update user set password=PASSWORD('thenewpass') where User='theusername';
flush privileges;
The first line says to use the "mysql" database which contains all the user info.
the second update line sets the new password "thenewpass" for the u........