Don't have Magento admin password

Question

Is there a way to change Magento back-end login and password using just cPanel and PHPMyAdmin? I cannot reset the password and if I attempt to reset the password It will email the developer who tried to screw me over. I now have a website I cannot log into. Any help will be greatly appreciated. Thanks.

---Update

So I changed it but I still unable to login > See pic. Is there something I'm missing?

Answer 1

I've not really used PHPMyAdmin, but you should be able to do something like the following:

UPDATE admin_user SET password = md5('password0123') WHERE username = 'username';

Answer 2

@Pradeep Sanku

i can't comment for lack of reputation but you need to remove a semicolon from the end of the setpassword line on your solution:

<?php
require_once('app/Mage.php'); //Path to Magento
umask(0);
Mage::app();

Mage::getModel('admin/user')
->loadByUsername('admin')
->setPassword("yournewpassword")
->save();

echo "Successfully Changed";
?>

I tried both the query solution and the php one but I still get access denied :(

Answer 3

if you have access to the ftp.you can create php file with following code

<?php
require_once('app/Mage.php'); //Path to Magento
umask(0);
Mage::app();

Mage::getModel('admin/user')
->loadByUsername('admin')
->setPassword("yournewpassword")
->save();

echo "Successfully Changed";
?>

and place this file at magento root directory (where you will see your index.php) and run this file using http://www.urlofwebsite.com/resetpassword.php