OpenCart Community

readyman wrote:Here are the steps required

Step One: Login to phpmyadmin
Step Two: Choose the user table
Step Three: Edit the admin user
Step Four: Enter new details in user record

Full tutorial here: http://alreadymade.com/web/archives/157

Link above does not work. Can you provide an update?

Thanks!

generics24 wrote:

TBT wrote:use MySQL Query Browser (if you have it) and exacute this query

UPDATE user SET password=md5('password') WHERE user_id = 1;

that would change it to the word password

but yes would be nice to have a forgotten password in admin login

I Owe you one, Thanks a Ton Man, I was in a panic mode, you saved my day.

Thanks

TBT,

I entered your query in phpMyAdmin > localhost > my store > SQL "Run SQL query/queries on database "my store":" and clicked on "Go" and see:

"0 rows affected. Query took 00.00002 sec"

I then tried to login with "password" and can't get anywhere. What username do I use? It's possbile that it got wiped out as well when I tried to upgrade my Open Cart from 1.4.7 to 1.4.9.3

Where did I go wrong implementing your instructions?

thanks!

Open Cart Administrator Password Reset tool.