Forums / Installing on a Mac Server / admin password reset

admin password reset

Views: 24,775

Results 1 to 4 of 4
5 Mar 2019, 9:33 PM
#1
looper avatar

looper

New Zenner

Join Date:
Aug 2006
Posts:
52
Plugin Contributions:
0

admin password reset

I am on a local server. did a perfect install. have been able to sign in to my Admin. But now I cannot and I guess I have forgotten it(err) So I am trying to do the reset thingy. I have changed my admin. but for the life of me I am not getting where to make the changes. I have done this before. So If my admin is lets say, "ABC", where do I make the changes? Thank you!

DELETE FROM admin WHERE admin_name = 'Admin';
INSERT INTO admin (admin_name, admin_email, admin_pass, admin_level)
VALUES ('Admin', 'admin@localhost', '351683ea4e19efe34874b501fdbf9792:9b', 1);

MBP loaded
Zen Cart 1.5.6
XAMPP 7.3.1 Includes: Apache 2.4.37, MariaDB 10.1.37, PHP 7.3.1, phpMyAdmin 4.8.4,

5 Mar 2019, 10:11 PM
#2
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

Re: admin password reset

There's no changes that need to be made.

Use the above sql to establish a login that uses the credentials associated with it. Login to your admin, go to the admin section admin users, change/set the password for your ABC admin.

Log out, then login with the credentials for ABC.
Upon success, delete the Admin user created by the sql.

Does that make sense or are trying to do something more?

ZC Installation/Maintenance Support <- Site
Contribution for contributions welcome...

5 Mar 2019, 10:22 PM
#3
looper avatar

looper

New Zenner

Join Date:
Aug 2006
Posts:
52
Plugin Contributions:
0

Re: admin password reset

Just trying to reset my admin. So I’m trying to do it in phpmyadmin, etc.

MBP loaded
Zen Cart 1.5.6
XAMPP 7.3.1 Includes: Apache 2.4.37, MariaDB 10.1.37, PHP 7.3.1, phpMyAdmin 4.8.4,

5 Mar 2019, 10:31 PM
#4
looper avatar

looper

New Zenner

Join Date:
Aug 2006
Posts:
52
Plugin Contributions:
0

Re: admin password reset

Ok
Got what you said. It worked. Hugh thanks.!!

MBP loaded
Zen Cart 1.5.6
XAMPP 7.3.1 Includes: Apache 2.4.37, MariaDB 10.1.37, PHP 7.3.1, phpMyAdmin 4.8.4,