Forums / General Questions / Can't login or reset password

Can't login or reset password

Started by 1mweeks on 3 Jan 2015, 1:52 PM · Views: 843

Results 1 to 5 of 5
3 Jan 2015, 1:52 PM
#1
1mweeks avatar

1mweeks

New Zenner

Join Date:
Apr 2009
Posts:
11
Plugin Contributions:
0

Can't login or reset password

I've been searching for awhile, and maybe missing something easy but I can't login or reset my password and not sure where to look.

Tried e-mailing it, didn't work.

Logged into mysql and ran this code (I have 1.3 and the configure.php shows "define('DB_PREFIX', 'store');" as a prefix):

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

The response I keep getting is this:

SQL query:

DELETE FROM store_admin WHERE admin_name = 'Admin';

MySQL said: Documentation
#1146 - Table 'hailivestore.store_admin' doesn't exist

Any thoughts what to try next? Thanks again for the help in advance!

3 Jan 2015, 3:10 PM
#2
stevesh avatar

stevesh

Black Belt

Join Date:
Feb 2005
Location:
Lansing, Michigan USA
Posts:
19,793
Plugin Contributions:
2

Re: Can't login or reset password

Did you see this in the tutorial?

NOTE: If you are using a prefix for your database tables, you'll naturally need to add that prefix to the table name above.
ie. "DELETE FROM prefix_admin ... " and "INSERT INTO prefix_admin ..." ... replacing "prefix_" with your actual tablename prefix.

3 Jan 2015, 3:31 PM
#3
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,515
Plugin Contributions:
176

Re: Can't login or reset password

@stevesh, he already posted that he used 'store_' as the prefix.

@1Mweeks: However, the error is that DB_PREFIX is 'store', not 'store_' ... so the tablename shouldn't be 'store_admin'; it should be 'storeadmin'.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

13 Jan 2015, 5:03 AM
#4
tmacarle avatar

tmacarle

New Zenner

Join Date:
Sep 2011
Posts:
19
Plugin Contributions:
0

Re: Can't login or reset password

I apologize if this is not supposed to be here, but I am having the same problem. This is the first issue I have ever had losing a password, but I tried to log in and the password was incorrect. I of course tried every variation I have ever thought of, and then tried the 'forgot password' link. The email never came to any of my inboxes, and I even got a green text reading that it was sent. I have found in the 'configure' php the username and password for the DB but this is for the database, not the admin panel. I cannot figure out how to reset this or get into my admin website, can anyone please help me with this issue at least with something to try? Thank you. I am using version 1.5

13 Jan 2015, 6:15 AM
#5
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,515
Plugin Contributions:
176

Re: Can't login or reset password

tmacarle:

I apologize if this is not supposed to be here, but I am having the same problem. This is the first issue I have ever had losing a password, but I tried to log in and the password was incorrect. I of course tried every variation I have ever thought of, and then tried the 'forgot password' link. The email never came to any of my inboxes, and I even got a green text reading that it was sent. I have found in the 'configure' php the username and password for the DB but this is for the database, not the admin panel. I cannot figure out how to reset this or get into my admin website, can anyone please help me with this issue at least with something to try? Thank you. I am using version 1.5
You will probably need to reset it using phpMyAdmin: http://www.zen-cart.com/content.php?44-how-do-i-change-or-reset-my-admin-password

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.