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
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
http://www.alreadymade.com
Follow me on twitter.com/alreadymade
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?
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?
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??
(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??
I didn't tested it yet but thanksphpuk 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 think it would be nice to add password recovery (send new password to admin email) in OpenCart.
.
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
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
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
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.
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 ;-)
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.
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 toolilovekhym 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.
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.
Who is online
Users browsing this forum: Bing [Bot] and 101 guests