Update Admin Password By Mysql

General Forums General Questions
#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 !

#2

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

#3

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

#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 !

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

#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/

#7

Problem appear when Cs-cart is instaled without “www”
For who don`t work this metode to change password, go to config.local.php and add “www” in front of your domain.

// Host and directory where software is installed on secure server
$config[‘https_host’] = ‘www.yourdomain.com’;

Now password that you enter on cs-cart instalation works, and work resetting password to