If you have used  WordPress Suicide plugin, you know what I am talking about. Every time I do this, I go around reading all PHP files to figure out the tables and columns and their meaning.
Here is a quick one. I am using mySQL client.Â
Add your admin account back:
insert wp_users (user_login, user_pass, user_nicename, user_email, user_url, user_registered, user_activation_key, user_status, display_name) values (‘admin’, md5(‘your-admin-password’), ‘admin’, ‘youremail@whatevermail.com’, ‘yoururl@yoursite.com’, ”, ”, 0, ‘admin’);
Check what the id is:
select * from wp_users where user_login = ‘admin’;
Add two entries to user meta table to get the privileges:
insert into wp_usermeta (user_id, meta_key, meta_value) values (1, ‘wp_capabilities’, ‘a:1:{s:13:”administrator”;b:1;}’);
insert into wp_usermeta (user_id, meta_key, meta_value) values (1, ‘wp_user_level’, 10);
I did not spend enough time to figure out what those entries mean. But this will get you back in to the admin console.Â