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: |
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.
|
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.
|
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? |
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 |
Re: how to change admin password in database
Quote:
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 ... |
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 |
Re: how to change admin password in database
Quote:
ya..i can login on customer side with that password.....:roll: |
Re: how to change admin password in database
Quote:
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 01:22 PM. |
Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.