lost clients admin password - restarted through mysql - cant access any admin profile

So I forget my clients master password which I only use.. admin was named masteradmin (I looked from sql). I cannot send passwords through email it is disabled. I ran the script

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);

which lets me in but I cannot see the menu so I think admin roles mod(or something similar) messes things up. I need this urgently so please please help. Im totally lost with this one.

Im basically fired if I don't find out a way to fix this.. I tried this

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

which lets me in as masteradmin with pw admin BUT still no menu and
"Sorry, your security clearance does not allow you to access this resource."

If you're using the admin profiles mod, you'll have to set up the security in the admin profiles tables manually.

Im not really that handy with the mysql and wouldnt really want to make this issue even huger but do I need to reset the table? I don't have admin profiles table? theres admin_allowed_pages table though? How can I reset it? thanks Byte!

You may have to study the admin profiles contribution documentation for more information.

I have to run off to a meeting, so can't help at this moment.

Before trying to reset it (which you could do by re-running the installation SQL bundled with the Admin Profiles release package) which would be a complete reset, that would wipe out all settings for other users too, try this ...

Go into your admin table (e.g. via phpMyAdmin) and edit your admin_id to be "1".

Thanks Kuroi. Glad that you found the thread. I was looking for your help already in the profiles thread :) So actually how I set admin id in to 1?

I was nudged here. You can update it by editing the table contents in phpMyAdmin or similar. But maybe easier would be to just run the following SQL> update admin set admin_id=1 where admin_name="masteradmin";

Unfortunately I need to go out too. But Let me know how that goes. I'll check-in when I return.

Thanks guys I figured it out and you cannot imagine how relieved I am! cheers!

for the others who're not so fluent with sql

https://www.zen-cart.com/tutorials/index.php?article=95

This Is Awesome - Thanks For The Hash Code

Any time you need it, it's in the FAQ. Just search for "admin password"