How to reset Magento user password cPanel:

If you forgot your Magento username or password then you can reset it by accessing the Magento database. This can be done either from the back end or from your cPanel. You can follow the steps below to change username or password of the Magento CMS,

Step 1.

Login to cPanel

Step 2.

Select the option phpMyAdmin” from the tab Databases.

Step 3.

On phpMyAdmin go to the Databases option and select the database used by the Magento CMS.

Step 4.

After selecting the Database open the SQL option from the above tab and update the user and password details to the database using the following mysql command,

UPDATE `admin_user` SET `password` = MD5('Passwordfortheuser') WHERE `username` = 'username_of_magento_admin';

You need to replace Passwordfortheuser and username_of_magento_admin 

with the corresponding values, For example,

UPDATE `admin_user` SET `password` = MD5('@#tv^&') WHERE `username` = 'iserver';

After that you can login to your Magento website using the updated password.

That’s all

If you need our help to fix any issues on your server. Please feel free to contact us, simply email to [email protected]

Monthly server support with Unlimited tickets, 24×7 monitoring, Security Audit and lot more for just $59