how to change admin password in database

Vetrivel · #1 05-23-2008, 01:28 AM

hi frnds,
may i know how to change admin password in database.
which table i need to touch.
can u please guide me..

pauldodman · #2 05-23-2008, 06:55 AM

It's in the customers table - but it's encrypted - as you'd expect - so you won't really have much luck if you do change it.

JWait · #3 05-23-2008, 08:25 AM

Its easier to change it from within x-cart. Did you lock yourself out or something? If so, just use the "recover password" feature and have the password emailed to you. It may be gibberish because of the encryption but just copy and paste it and you should be ok. It sounds like maybe the blowfish key was changed somehow, and if so it will change every password in the database.

Vetrivel · #4 05-25-2008, 08:03 PM

thanks to both of you..

i cant login now bec,
i changed password in database (i copied customer password (encrypted one ) and pasted it in admin account )...i dont know how to get out of this issue.. plz help me..
and since i m using my site in localhost recover password option not emailing the password to my account..
what to do now?

BritSteve · #5 05-26-2008, 05:16 AM

If you still have access to the customer side, and have a utility like phpmyadmin, you could probably do the following.

Create a new customer/member account with a password
Make a note of the password you used.
go into phpmyadmin
find the new customrt row.
Copy and paste it into the password field on the admin row.
Log into the admin area using the password you wrote down.

I can't see why this wouldn't work.

Steve

Vetrivel · #6 05-26-2008, 06:02 AM

Quote:

Originally Posted by BritSteve

If you still have access to the customer side, and have a utility like phpmyadmin, you could probably do the following.

Create a new customer/member account with a password
Make a note of the password you used.
go into phpmyadmin
find the new customrt row.
Copy and paste it into the password field on the admin row.
Log into the admin area using the password you wrote down.

I can't see why this wouldn't work.

Steve

thnks for your reply BritSteve
Actually i copied the existing customer password and pasted it in admin password field .. but i get the same result..... is ther any other way ...

BritSteve · #7 05-26-2008, 06:49 AM

I don't know what you are doing differently, but I just tried my solution and it worked just fine. Do you know the password of any of the logins in the customer table?

Steve

Vetrivel · #8 05-26-2008, 07:41 PM

Quote:

Originally Posted by BritSteve

I don't know what you are doing differently, but I just tried my solution and it worked just fine. Do you know the password of any of the logins in the customer table?

Steve

ya..i can login on customer side with that password.....

phkcorp2005 · #9 10-04-2013, 04:38 AM

Quote:

Originally Posted by BritSteve

If you still have access to the customer side, and have a utility like phpmyadmin, you could probably do the following.

Create a new customer/member account with a password
Make a note of the password you used.
go into phpmyadmin
find the new customrt row.
Copy and paste it into the password field on the admin row.
Log into the admin area using the password you wrote down.

I can't see why this wouldn't work.

Steve

There is an improved way which I verified work on version 4.5.0.
1. Create a new customer account
2. Log into phpmyadmin and browse the customer table to locate the record for the newly created customer
3. Change the usertype from C to A for this customer.
4. You can now log into admin using your new user.
5. After your log into admin, change the admin password.