lost my password for joomla admin

Well, it happens! the best way to deal with this is to go to phpmyadmin then go the the joomla database then …