Post by fergie3 » Mon Feb 28, 2011 10:14 am

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:

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

Thanks! 8)



Wed Feb 16, 2011 11:46 am

Post by JAY6390 » Mon Feb 28, 2011 10:18 am


SEO MEGA KIT PLUS - Get your site ranking higher in the search engines
Better Product SEO URL's - Perfectly structured product links
SEO URL's Route Editor PRO - Make ANY url on your site have clean keywords - even third party extensions (remove index.php)

User avatar
Guru Member


Wed May 26, 2010 11:47 pm
Location - United Kingdom

Post by fergie3 » Mon Feb 28, 2011 1:33 pm

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 ;D

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

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



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

Where did I go wrong implementing your instructions? ???



Wed Feb 16, 2011 11:46 am

Post by CEOself » Mon Apr 04, 2011 4:52 am




Tue Dec 29, 2009 3:05 pm

Post by i2Paq » Mon Apr 04, 2011 5:23 am

Norman in 't Veldt
Moderator OpenCart Forums

_________________ READ and Search BEFORE POSTING _________________

Our FREE search: Find your answer FAST!.

[How to] BTW + Verzend + betaal setup.

User avatar
Global Moderator


Mon Nov 09, 2009 7:00 pm
Location - Winkel - The Netherlands
Who is online

Users browsing this forum: No registered users and 66 guests