X-Cart: shopping cart software

X-Cart forums (https://forum.x-cart.com/index.php)
-   Changing design (https://forum.x-cart.com/forumdisplay.php?f=51)
-   -   how to change admin password in database (https://forum.x-cart.com/showthread.php?t=39986)

Vetrivel 05-23-2008 01:28 AM

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

pauldodman 05-23-2008 06:55 AM

Re: how to change admin password in database
 
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 05-23-2008 08:25 AM

Re: how to change admin password in database
 
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 05-25-2008 08:03 PM

Re: how to change admin password in database
 
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 05-26-2008 05:16 AM

Re: how to change admin password in database
 
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 05-26-2008 06:02 AM

Re: how to change admin password in database
 
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 05-26-2008 06:49 AM

Re: how to change admin password in database
 
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 05-26-2008 07:41 PM

Re: how to change admin password in database
 
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.....:roll:

phkcorp2005 10-04-2013 04:38 AM

Re: how to change admin password in database
 
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.


All times are GMT -8. The time now is 02:23 PM.

Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.