accidentally deleted the "Admin" entry in phpmyadmin

So I was unable to login to my cart with the normal credentials. I then went into phpmyadmin and noticed that the "Admin" username had been changed. -probably by the other guy who has access to the site.

While in there, I accidentally deleted the only admin entry.

Now I try to run

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

But there is no "Admin" in there.

When looking at the database, I still see zen_admin. But now when I click on it, it returns an "empty result set".

Can someone provide a script to run that will populate "admin" with basic information? Like username: admin Password: admin

Thanks :)

When looking at the database, I still see zen_admin. But now when I click on it, it returns an "empty result set".

Try this as I have added your DB prefix

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

OMG, I can't believe I didn't see that!!

You genius, me NOT!!

:lamo: