The commands below will help you reset any mysql user password.
use mysql;
update user set password=PASSWORD('thenewpass') where User='theusername';
flush privileges;