Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

Update Admin Password By Mysql Rate Topic   - - - - -

 
  • michael
  • Senior Member
  • Authorized Reseller
  • Join Date: 27-Oct 06
  • 233 posts

Posted 21 August 2020 - 09:12 AM #1

Hi, I want to reset the admin password to "password" by below command:

UPDATE cscart_users SET password='5f4dcc3b5aa765d61d8327deb882cf99' WHERE user_id='1';

But it looks like still can not login, anyone know what's the problem ? Thank you very much !


Do whatever you want to do....

 
  • eComLabs
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 27-Jan 14
  • 21883 posts

Posted 21 August 2020 - 01:40 PM #2

Try to set value of the 'salt' column to empty string as well


GET A FREE QUOTE | CS-Cart Add-ons | CS-Cart Licenses | CS-Cart Development | CS-Cart Design | Server Configuration | UniTheme and YOUPI
CS-Cart                USD 345     Multi-Vendor              USD 1250    Multi-Vendor PLUS           USD 3100 (2775)
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      Multi-Vendor Ultimate       USD 7500 (6000)

 
  • tbirnseth
  • CS Cart Expert
  • Authorized Reseller
  • Join Date: 08-Nov 08
  • 12052 posts

Posted 21 August 2020 - 08:02 PM #3

Why not just use the 'lost password' link which will let you reset?


EZ Merchant Solutions: Custom (USA based) B2B Development, Consulting, Development and Special Projects (get a quote here).
Commercial addons, payment methods and modifications to meet your business and operations needs.


 
  • michael
  • Senior Member
  • Authorized Reseller
  • Join Date: 27-Oct 06
  • 233 posts

Posted 22 August 2020 - 05:58 AM #4

Try to set value of the 'salt' column to empty string as well

Thank you very much , it worked.


Why not just use the 'lost password' link which will let you reset?

Because the SMTP still not configured, so can not receive the reset password link by Email. Thanks anyway !


Do whatever you want to do....

 
  • parodius420
  • Senior Member
  • Members
  • Join Date: 03-Dec 11
  • 614 posts

Posted 01 April 2021 - 12:19 AM #5

Where did you put this string at?  I am having the same issue, can't log in to admin, and password change in cpanel I can't get right.  Thanks.



 
  • eComLabs
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 27-Jan 14
  • 21883 posts

Posted 01 April 2021 - 05:10 AM #6

In the phpmyadmin use

UPDATE cscart_users SET password='5f4dcc3b5aa765d61d8327deb882cf99', salt = '' WHERE user_id='1';

MD5 hash of new password can be generated here

 

http://www.md5.cz/


GET A FREE QUOTE | CS-Cart Add-ons | CS-Cart Licenses | CS-Cart Development | CS-Cart Design | Server Configuration | UniTheme and YOUPI
CS-Cart                USD 345     Multi-Vendor              USD 1250    Multi-Vendor PLUS           USD 3100 (2775)
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      Multi-Vendor Ultimate       USD 7500 (6000)