Admin USer & Password no loner work.

barco57:

do you have a prefix on your database tables? (i.e. zen_)

I think no. I am using the system as default.

you'll need to confirm whether or not you are using prefixes on the database. Easy to do in phpmyadmin...does the admin table just say admin or does it say zen_admin or something like that.

Posted via Mobile Device

When I run this command:

  DROP TABLE IF EXISTS admin;

CREATE TABLE admin (
admin_id int(11) NOT NULL auto_increment,
admin_name varchar(32) NOT NULL default '',
admin_email varchar(96) NOT NULL default '',
admin_pass varchar(40) NOT NULL default '',
admin_level tinyint(1) NOT NULL default '1',
PRIMARY KEY (admin_id),
KEY idx_admin_name_zen (admin_name)
) TYPE=MyISAM;

then the message I receive is this:

Your SQL query has been executed successfully

SQL query:
DROP TABLE IF EXISTS admin;# MySQL returned an empty result set (i.e. zero rows).
CREATE TABLE admin(
admin_id int( 11 ) NOT NULL AUTO_INCREMENT ,
admin_name varchar( 32 ) NOT NULL default '',
admin_email varchar( 96 ) NOT NULL default '',
admin_pass varchar( 40 ) NOT NULL default '',
admin_level tinyint( 1 ) NOT NULL default '1',
PRIMARY KEY ( admin_id ) ,
KEY idx_admin_name_zen( admin_name )
) TYPE = MYISAM ;# MySQL returned an empty result set (i.e. zero rows).

Now, you can see if the table consists of any prefix or not.

I have not much knowledge about this php and all that.
If you can help me, then i will be very thankful to you.

regards and hoping to receive an answer early.

I found it ......

it is zen_admin in the table.
now what to do, please reply soon... thanks.

These are the sql statements that you need. Notice the only thing I changed was to put the zen_ before the table name.

 DROP TABLE IF EXISTS zen_admin;
CREATE TABLE zen_admin (
  admin_id int(11) NOT NULL auto_increment,
  admin_name varchar(32) NOT NULL default '',
  admin_email varchar(96) NOT NULL default '',
  admin_pass varchar(40) NOT NULL default '',
  admin_level tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (admin_id),
  KEY idx_admin_name_zen (admin_name)
) TYPE=MyISAM;  

then

 INSERT INTO zen_admin VALUES (1, 'Admin', 'admin@localhost', '351683ea4e19efe34874b501fdbf9792:9b', 1);  

take notice of the difference Admin (username), admin (password)

I pasted the same codes given by you in SQL tab.

the first code and then closed the run query window and then again opened it and pasted the second code.
But I am still unable to login using username Admin and password admin.

please suggest where am I wrong.

thanks.

The Admin login page has a link to "Resend Password". Have you tried that?

Note: you would have to verify that "zen_admin" TABLE is using one of your eMail addresses.

How can I check that the zen_admin table is using my email address : [email protected]

please help me, I am in real trouble.

or can you please check out my control panel and repair the thing?

I looked up at the zen_admin table and found that the admin name is muteyaar and the admin email is [email protected] , which my own email address.

now what should I do? please suggest.
thanks.

I got it cleared. Thanks a ton for your help.:-):-):-):-):-):-) > SHokuf:

I used this page: https://www.zen-cart.com/tutorials/index.php?article=2

And got the admin to login.
Posted via Mobile Device

when it asked to reset password, I enter email address and it says it has sent the new password, but it never arrives. Any help to find this file to change it manually??? HELP :)
Kathy

You could reset your admin table in the database via phpMyAdmin using:

DROP TABLE IF EXISTS admin;
CREATE TABLE admin (
  admin_id int(11) NOT NULL auto_increment,
  admin_name varchar(32) NOT NULL default '',
  admin_email varchar(96) NOT NULL default '',
  admin_pass varchar(40) NOT NULL default '',
  admin_level tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (admin_id),
  KEY idx_admin_name_zen (admin_name),
  KEY idx_admin_email_zen (admin_email)
) TYPE=MyISAM;

INSERT INTO admin VALUES (1, 'Admin', 'admin@localhost', '351683ea4e19efe34874b501fdbf9792:9b', 1);

This will set an account for you with theL
Login: Admin
Password: admin

NOTE: be sure to change these settings in the Tools ... Admin Settings ...

WARNING: This deletes ALL records in the admin table first and then adds a clean record ...