lost my joomla administrator password

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