Help! Locked out of my own store!

I may be getting closer to where to look or run that query. I'm here:

Field 	Type 	Collation 	Attributes 	Null 	Default 	Extra 	Action
admin_id 	int(11) 			No 		auto_increment 	Browse distinct values 	Change 	Drop 	Primary 	Unique 	Index 	Fulltext
admin_name 	varchar(32) 	latin1_swedish_ci 		No 			Browse distinct values 	Change 	Drop 	Primary 	Unique 	Index 	Fulltext
admin_email 	varchar(96) 	latin1_swedish_ci 		No 			Browse distinct values 	Change 	Drop 	Primary 	Unique 	Index 	Fulltext
admin_pass 	varchar(40) 	latin1_swedish_ci 		No 			Browse distinct values 	Change 	Drop 	Primary 	Unique 	Index 	Fulltext
admin_level 	tinyint(1) 			No 	1 		Browse distinct values 	Change 	Drop 	Primary 	Unique 	Index 	Fulltext

With selected: Check All / Uncheck All With selected: Browse Change Drop Primary Unique Index Fulltext
Print viewPrint view Propose table structurePropose table structureDocumentation
Add new fieldAdd field(s)At End of Table At Beginning of Table After
Indexes: Documentation Keyname Type Cardinality Action Field
PRIMARY PRIMARY 2 Edit Drop admin_id
idx_admin_name_zen INDEX None Edit Drop admin_name
idx_admin_email_zen INDEX None Edit Drop admin_email
admin_email FULLTEXT None Edit Drop admin_email
admin_email_2 FULLTEXT None Edit Drop admin_email
The following indexes appear to be equal and one of them should be removed: admin_email, admin_email_2

I think I'm getting close. I've found the zen_admin folder/database/table (whatever it's called) and is shows all those entrys listed in my previous post.
If I try the sql query from this location, it has an entry in the box that says:

SELECT * FROM zen_admin WHERE 1

Should I replace this text with this:

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

or leave that text there and add it to the next line?

Or neither?

mpcustom:

I have just gone through the same thing this morning. I just got the SSL Cert yesterday and it points to the www prefix. Basically, I went back to the two configure files and changed the HTTP_SERVER's to http://your_site.com and I set the ENABLE_SSL_CATALOG and SSL_ADMIN to 'false'.
I was then able to log in to the admin CPanel, change the password. From there I changed the configure settings back one by one, quitting the browser each time and relogging into admin CPanel. For whatever reason, this has worked for me.
Mike

BTW Thanks mpcustom, but my ssl was working for many weeks before this came up so I don't think that's it.

fishingmaniac:

SELECT * FROM zen_admin WHERE 1If your admin table is named "zen_admin", along with all your other tables having a "zen_" prefix, then ... as the FAQ article on resetting the admin password indicates, you'll need to substitute "zen_admin" for the table name in the query.

So ... change it like this:```
DELETE FROM [B]zen_[/B]admin WHERE admin_name = 'Admin';
INSERT INTO [B]zen_[/B]admin (admin_name, admin_email, admin_pass, admin_level)
VALUES ('Admin', 'admin@localhost', '351683ea4e19efe34874b501fdbf9792:9b', 1);

Bingo! (again!) That worked.:clap: BTW for us novices, I had to run that from the proper area in phpMyAdmin: from the database folder _zc1 and, since I have two databases, and was unsure about which one to use, I used _zc2 also. Now to try to figure out how to get the resend password to work properly before I get locked out again.
Why might that not have worked? It said in the phpMyAdmin that I had duplicate email addresses for my admin usernames (true as they were both for me). So I deleted one, and made the other my sales@my_domain.com I'm scared to try it!