News:

AbanteCart v1.4.2 is released.

Main Menu

How to reset admin password via SQL

Started by jaysbar, June 10, 2015, 05:41:04 AM

Previous topic - Next topic

jaysbar

Hi

I have been using Abantecart with the same username and password for around 2 months. Today it decided that the combination of username and password is not valid! I know there are hacks to get around this, but I want to know how to change the password via SQL Admin using the abc_Users table. I can see that there is a Password field with an encrypted password. Can I replace it with say "Password" ?

Thanks



jaysbar

Thanks for the prompt reply and tips.

Forgot password is not working because it claims that I am not entering the verification code correctly. Tried about 10 times.

BTW I am running Abantecart 1.2.2.

I tried changing my password in SQL to "Password" and I still cannot login to my AbanteCart admin page.... It's crippling!

Basara

Try another browser. Can you please post what is your OS and browser version

jaysbar

Hi

I tried the RESET password link in IE and FF and it tells me the verification code is wrong. I tried the same in Chrome and it works fine. However I do not have my SMTP configured in ABanteCarte. Can I do this manually by editing some files via FTP?

Basara

Hi.

Can you please post your operating system version?
About SMTP settings - all settings stored in database.

jaysbar

Hi

Personal PC which I use for FTP etc is on Win 7 x64

My site is hosted on CPanel with PHP 5.3

I'm wondering if it's just easier to revert to a backup from a week ago. But I will loose some of my config changes since the last backup.

Basara

I think you miss links I posted before  :)

check this solution http://forum.abantecart.com/index.php/topic,547.msg1688.html#msg1688 you can see your password with this modification

jaysbar

Hi Basara

I edited my Forgot_Password.php file and changed $Password = 'Password'. I put the Forgot_Password.php file back to the FTP site. What should I do next?

The instructions say "Run reset password in admin and new password will be saved.". What does this mean?

Basara


jaysbar

Hi

I tried the reset password thing and when I click on "reset password" the page goes white and blank.

jaysbar

I'm giving up. Am performing a reinstall :(

jaysbar

I reinstalled and restored my DB and content as best as I could.

PLEASE ensure you create an additional Admin account when you install AbanteCart. I have no idea how my default admin account password stopped working. The ebcrypted password looked exactly like my test site which had the same password - so baffled why it stopped working.

Forum Rules Code of conduct
AbanteCart.com 2010 -