OpenCart Community

how can I recover admin password?

Admin->user insert a new user alter the user group to Top Administrator.

Phil.

phpuk wrote:Admin->user insert a new user alter the user group to Top Administrator.

Phil.

well, when I have not admin password how can I login to admin?

Ha ha ha very good point

Use some thing like phpMyAdmin and open the user table.

replace the password of the top level user with this 5f4dcc3b5aa765d61d8327deb882cf99 this is the word "password" without the quotes.

Phil.

Hi, for some reason i couldnt login to my admin, i know the user/pw i have it wrote down. so i went to change the pw in phpmyadmin to that code for "password" but still didnt work. Im quite worried now - i dont have a clue about the phpmyadmin. could someone tell me how to create a new user in phpmyadmin please??

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

thanks for the reply readyman. Followed the link. Thats how i did it earlier, still no luck, do you think someone may have hacked my site?

I deleted the database and re-uploaded all my files and still the same thing?

I think i will reinstall and just upload all my modified files again. I think someone must have hacked my site because there's no way i entered the wrong pw in the first place, i only installed the site last week and had everything down on paper, And i have been accessing the admin area everyday since.

I wonder.....I posted the other day about an error i was getting, in the post i included my cpanel user name and my domain (mysite.com/user/public_html/) - can someone hack my site with that info??

Another thing i noticed is, in phpmyadmin > db > user settings, there was a foreign i.p address in the i.p field, is that normal? I noticed on the tutorial in that link the field is blank?

Ok this is very worrying. I can't get into my other sites admin area either?????? Anyone have any idea what may have caused this?

Did you use the same password on all of your sites?

Have you tried from another computer just in case you have an issue of some description on your pc.

ok right i know what i've done now. After reading a post somewhere about hackers and how to avoid them, i password protected my admin files - i thought this was just for accessing the files in my cpanel not in my sites admin

(but think about it - i am accessing the admin file one way or another)

I feel like an idiot now!!!
ok lesson learnt, all this is a bit of a learning curve for me. wow that had me baffled for a while.

So in phpmyadmin, im looking at the user table, there is a field "ip" with an ip address, who's ip is that though and should it even be there??

OpenCart captures the ip of the machine used to enter the user record.

phpuk wrote:Ha ha ha very good point

Use some thing like phpMyAdmin and open the user table.

replace the password of the top level user with this 5f4dcc3b5aa765d61d8327deb882cf99 this is the word "password" without the quotes.

Phil.

I didn't tested it yet but thanks
I think it would be nice to add password recovery (send new password to admin email) in OpenCart.

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

Hello

For some reason we are also not able to login using our user name and login details. There is no option for password recovery so have looked on OC forum for help. I reset the password in phpmyadmin but that did not work. Could someone explain "MySQL Query Browser"

What else can I do?

Thanks

fastdev !!!!!!!!

You are great....

I found out the password have criteria.

If got capital cannot login.

If more than 8 characters cannot login.

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

I would use the FREE Open Cart Administrator Password Reset tool

password stored in database hashed in md5 so I would use the http://www.adamek.biz/md5-generator.php to generate any string to md5 hash as password before do edit on phpmyadmin
because you can't put 'password' string in password column without hashed by md5.
its work for me, hope you too ;-)

Hello,

I just recently submitted an extension for this problem.

You can check it here:
http://www.opencart.com/index.php?route ... ion_id=879

The full installation instruction is on the Documentation Tab. Hope you like it. Good luck.

ilovekhym wrote:Hello,

I just recently submitted an extension for this problem.

You can check it here:
http://www.opencart.com/index.php?route ... ion_id=879

The full installation instruction is on the Documentation Tab. Hope you like it. Good luck.

I would use the FREE Open Cart Administrator Password Reset tool