Follow us on Twitter X-Cart on Facebook Wiki
Shopping cart software Solutions for online shops and malls

how to change admin password in database

 
Reply
   X-Cart forums > X-Cart 4 > Dev Questions > Changing design
 
Thread Tools Search this Thread
  #1  
Old 05-23-2008, 01:28 AM
  Vetrivel's Avatar 
Vetrivel Vetrivel is offline
 

eXpert
  
Join Date: Apr 2008
Posts: 398
 

Question 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..
Reply With Quote
  #2  
Old 05-23-2008, 06:55 AM
  pauldodman's Avatar 
pauldodman pauldodman is offline
 

X-Guru
  
Join Date: Jul 2003
Location: Spain / UK
Posts: 3,034
 

Default 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.
__________________
Paul Dodman
e-business & m-commerce consultant
w: www.luminointernet.com
e: xcart@luminointernet.com

Professional X-Cart help, advice, support and services, specialists in Mobile X-Cart.
Reply With Quote
  #3  
Old 05-23-2008, 08:25 AM
  JWait's Avatar 
JWait JWait is offline
 

X-Man
  
Join Date: Nov 2005
Location: California
Posts: 2,440
 

Default 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.
__________________
Two Separate X-Cart Stores
Version 4.4.4 Gold - X-AOM - Vivid Dreams Aquamarine (modified) - Linux
Mods - Newest Products - View All -, and a few others. Numerous upgrades from 4.0.x series.
Integrated with Stone Edge Order Manager + POS

Version 4.1.12 Gold (fresh install) - X-AOM - Linux
Mods - XCSEO free
Reply With Quote
  #4  
Old 05-25-2008, 08:03 PM
  Vetrivel's Avatar 
Vetrivel Vetrivel is offline
 

eXpert
  
Join Date: Apr 2008
Posts: 398
 

Default 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?
Reply With Quote
  #5  
Old 05-26-2008, 05:16 AM
 
BritSteve BritSteve is offline
 

eXpert
  
Join Date: Apr 2006
Posts: 339
 

Default 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
__________________
Version 4.1.8 & 4.1.9
ezcheckout4.1.x
cdseolinks2
product_metatags41x
shipping_per_product41x

http://www.earthsmagic.com
Reply With Quote

The following user thanks BritSteve for this useful post:
susilosaja (02-03-2016)
  #6  
Old 05-26-2008, 06:02 AM
  Vetrivel's Avatar 
Vetrivel Vetrivel is offline
 

eXpert
  
Join Date: Apr 2008
Posts: 398
 

Default 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 ...
Reply With Quote
  #7  
Old 05-26-2008, 06:49 AM
 
BritSteve BritSteve is offline
 

eXpert
  
Join Date: Apr 2006
Posts: 339
 

Default 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
__________________
Version 4.1.8 & 4.1.9
ezcheckout4.1.x
cdseolinks2
product_metatags41x
shipping_per_product41x

http://www.earthsmagic.com
Reply With Quote
  #8  
Old 05-26-2008, 07:41 PM
  Vetrivel's Avatar 
Vetrivel Vetrivel is offline
 

eXpert
  
Join Date: Apr 2008
Posts: 398
 

Default 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.....
Reply With Quote
  #9  
Old 10-04-2013, 04:38 AM
 
phkcorp2005 phkcorp2005 is offline
 

Newbie
  
Join Date: Mar 2011
Posts: 1
 

Default 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.
__________________
www.my-buy-it-now.com
Reply With Quote

The following user thanks phkcorp2005 for this useful post:
totaltec (10-04-2013)
Reply
   X-Cart forums > X-Cart 4 > Dev Questions > Changing design


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -8. The time now is 01:11 PM.

   

 
X-Cart forums © 2001-2020