InMotion Hosting Support Center

It can be hard to keep up with all the different passwords for your account. If you've forgot your admin password for OpenCart, you can reset the password in the database. You'll have to use phpMyAdmin in cPanel to change the password to the admin account. Since you'll be resetting the password to something easy like "password" it's very important to make sure once you are logged in to the OpenCart Admin Dashboard to change it to something more secure.

  1. Log into cPanel and click on phpMyAdmin
  2. Open the database that your OpenCart store uses
  3. Find the "user" table
  4. Edit the user with the username "admin" and change the password field to 5f4dcc3b5aa765d61d8327deb882cf99. This string or hash changes the password to "password" (without the quotes)
  5. opencart_admin_change_pass_1

  6. Click "Go"
  7. opencart_admin_change_pass_2

     

  8. Now, attempt to log into the OpenCart Dashboard with your new password

Be sure to change the password as soon as you log into the dashboard, since the password is insecure.

If you need further assistance please feel free to ask a question on our support center.


To find out more on using InMotion's web hosting solutions for OpenCart, click on OpenCart Hosting Accounts with Inmotion.

Continued Education in Course OpenCart
You are viewing Section 22: 339: How to reset my OpenCart Admin Password
Section 21: 340: How to find your database name for OpenCart
Section 23: 338: Creating a Voucher Template in OpenCart

Support Center Login

Social Media Login

   
Social Login Joomla

Related Questions

Here are a few questions related to this article that our customers have asked:
How do I reset my username and password for backend in opencart
Would you like to ask a question about this page? If so, click the button below!
Ask a Question
2013-07-06 7:50 am
you forgot to mention that when changing your password, you should choose md5 from dropdown list else the new password wont work.
Staff
9,968 Points
2013-07-08 2:21 pm
Hello designers.coders, and thanks for your comment.

In this particular case, because the "password" password has already been converted into MD5 format prior to adding it in phpMyAdmin. It is not necessary to select the MD5 type from the drop-down.

As mentioned in the article above, "Since you'll be resetting the password to something easy like "password" it's very important to make sure once you are logged in to the OpenCart Admin Dashboard to change it to something more secure."

We'll look at updating this article to make this a bit more clear, so thanks for pointing that out to us!

- Jacob
n/a Points
2014-03-04 2:02 am

Jacob-

please help!

I have done everything I can possibly think of... editing php is not resetting/defaulting password. i cannot for the life of me understand why I cant log into admin. Please any help!!!

Staff
11,156 Points
2014-03-04 11:52 am
Be sure that you are entering the correct information within the correct database. If you continue to have issues, I recommend contacting support in which they will be able to make changes for you if needed.
n/a Points
2014-04-23 8:43 pm

Have the same issue. Also did not work. Suprisingly I was password written when I created it, but it still says that password is incorrect...

Staff
24,830 Points
2014-04-23 9:22 pm
Hello Jelena,

Sorry to hear about the problems that you're having with the password. However, this article does give you the steps to manually change your password using phpMyAdmin in cPanel. If you don't have an account through InMotion, then you would need to use a database client in order to access the database to edit the existing password.

If you require further assistance, please provide us account information or at least the version of OpenCart that you're using.

Kindest regards,
Arnel C.
n/a Points
2014-05-10 11:38 pm

I followed the steps through altering the database and entering the password

 

5f4dcc3b5aa765d61d8327deb882cf99

it does not work!

Staff
27,163 Points
2014-05-12 12:00 pm
Hello Jaqueline,

I tested a fresh installation and the code 5f4dcc3b5aa765d61d8327deb882cf99 worked for me and I was able to log into the admin area with the password of 'password'. Please make sure that you are not setting the field to MD5 and that you do not have any extraneous spaces either before or after the code you enter.

Kindest Regards,
Scott M
n/a Points
2014-07-15 7:30 am

Thanks

n/a Points
2014-08-06 7:05 am

It worked perfect to me! Thanks!

n/a Points
2014-08-23 11:35 pm

It did not work for me. Is there another explanation? A problem with the server?

Staff
11,156 Points
2014-08-25 10:58 am
The steps, if followed exactly as written, should work flawlessly. Are you sure that you edited the correct database and table?
n/a Points
2014-11-21 7:45 pm
Perfect
n/a Points
2014-12-09 7:20 pm
Great! Thank-you---This Article was very helpful
n/a Points
2014-12-21 5:27 am

It didnt work for me. Thanks a lot for suport my previous problem. Now its a big issue for me 5 hours trying to recover my password. when i updated password it says-

1 row affected.

UPDATE `b4_15536624_muslimbd`.`oc_user` SET `user_id` = '1', `user_group_id` = '1', `password` = '5f4dcc3b5aa765d61d8327deb882cf99' WHERE `oc_user`.`user_id` =0;

i need urgent support please.

Staff
11,156 Points
2014-12-22 9:45 am
If you have more than one database, be sure that you are editing the correct database. Also, check your username to ensure that is correct as well.
n/a Points
2015-02-17 7:01 am

thanks. it works for me.

n/a Points
2015-02-27 6:42 pm

it works for me thank you very much

n/a Points
2015-04-10 7:47 am

check all ur procedue butnot work , correct id n password doent sho error but not work too

Staff
16,204 Points
2015-04-10 2:07 pm
Hello book,

Thank you for contacting us. It is possible that errors are being suppressed. Turning on error reporting in OpenCart may provide a more detailed message.

We are happy to help further, but will need some additional information.

What version of OpenCart are you using?

What Themes, and 3rd party addons do you have installed?

Thank you,
John-Paul

Post a Comment

Name:
Email Address:
Phone Number:
Comment:
Submit

Please note: Your name and comment will be displayed, but we will not show your email address.

22 Questions & Comments

Post a comment

Back to first comment | top

Need more Help?

Search

Ask the Community!

Get help with your questions from our community of like-minded hosting users and InMotion Hosting Staff.

Current Customers

Chat: Click to Chat Now E-mail: support@InMotionHosting.com
Call: 888-321-HOST (4678) Ticket: Submit a Support Ticket

Not a Customer?

Get web hosting from a company that is here to help. Sign up today!