Admin Abilities Gone

Hi forda21,

That doesn’t sound good! Maybe you may want to add a new administrator account. Then you can login and change your one back to being an administrator.

Hopefully you have some MySQL client experiance or access to phpMyAdmin.

If so then you can execute the below queries.

INSERT INTO wp_users (user_login, user_pass, user_nicename, user_email, user_url, user_status, display_name) VALUES (‘****NEWUSERNAME****’, MD5(‘****password****’), ‘friendly-name’, ‘[email protected]’, ‘http://example.com’, ‘0’, ‘Your Name’);
SELECT LAST_INSERT_ID() INTO @userid;
INSERT INTO wp_usermeta (umeta_id, user_id, meta_key, meta_value) VALUES (NULL, @userid, ‘wp_capabilities’, ‘a:1:{s:13:”administrator”;s:1:”1″;}’), (NULL, @userid, ‘wp_user_level’, ’10’);

All you need to do is change the values that are encapsulated by ‘****’.

I hope this helps, if not feel free to drop me a message and maybe I can assist you further.

Cheers

Strange… I just that snippet all the time.

Paste the code you are running and the error

Ok

Good to know

Now run the below

SHOW TABLES;

And paste the output

Great.

In that case, run the below:

INSERT INTO wp_3w4c89_users (user_login, user_pass, user_nicename, user_email, user_url, user_status, display_name) VALUES ('****NEWUSERNAME****', MD5('****password****'), 'friendly-name', '[email protected]', 'http://example.com', '0', 'Your Name');
SELECT LAST_INSERT_ID() INTO @userid;
INSERT INTO wp_3w4c89_usermeta (umeta_id, user_id, meta_key, meta_value) VALUES (NULL, @userid, 'wp_capabilities', 'a:1:{s:13:"administrator";s:1:"1";}'), (NULL, @userid, 'wp_user_level', '10');