How to reset admin password via SQL

[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

[Basara]

Try Forgot Password if you can not login
Also check this
http://forum.abantecart.com/index.php/topic,547.msg1688.html#msg1688
http://forum.abantecart.com/index.php/topic,3183.msg13544.html#msg13544

[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]

This mean you need visit forgotten password page www.yoursite.com/index.php?rt=index/forgot_password&s=your_admin

and reset password

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