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
Did you find this article helpful?

We value your feedback!

Why was this article not helpful? (Check all that apply)
The article is too difficult or too technical to follow.
There is a step or detail missing from the instructions.
The information is incorrect or out-of-date.
It does not resolve the question/problem I have.
How did you find this article?
Please tell us how we can improve this article:
Email Address
Name

new! - Enter your name and email address above and we will post your feedback in the comments on this page!

Related Questions

Here are a few questions related to this article that our customers have asked:
Ooops! It looks like there are no questions about this page.
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
9,384 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
17,716 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
20,113 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
9,384 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?

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.

12 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!