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: http://alreadymade.com/web/archives/157

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

Thanks! 8)

Newbie

Posts

Joined
Wed Feb 16, 2011 11:46 am

User avatar
Guru Member

Posts

Joined
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.

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? ???

Newbie

Posts

Joined
Wed Feb 16, 2011 11:46 am

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

thanks!

Newbie

Posts

Joined
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

Posts

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

Users browsing this forum: Bing [Bot] and 114 guests