Changing a wordpress user to an admin

wordpress

Solution

To set the `capabilities` and `user_level` your `meta_key` value needs to match your database prefix. By default this is `wp_` (resulting in `wp_capabilities` and `wp_user_level`) however it would be different in your case as you don't have a prefix. The proper `capabilities` value is `a:1:{s:13:"administrator";s:1:"1";}`.

-- delete any existing values for this user
DELETE FROM usermeta WHERE user_id=376 AND (meta_key LIKE '%capabilities' OR meta_key LIKE '%user_level')
-- insert the capabilities and user_level for user_id 376
INSERT INTO usermeta(user_id,meta_key,meta_value) VALUES(376, 'capabilities', 'a:1:{s:13:"administrator";s:1:"1";}');
INSERT INTO usermeta(user_id,meta_key,meta_value) VALUES(376, 'user_level', 10);

Problem

I am trying to set up a local copy of a production Wordpress blog. On production, I am a user but not an admin, so I am trying to change myself to an admin locally. I was following the directions on this blog post to make myself an admin, so I performed the following SQL queries: ``` INSERT INTO usermeta(user_id,meta_key,meta_value) VALUES(376, 'wp_capabilities', 'a:1:{s:13:"administrator";b:1;}'); INSERT INTO usermeta(user_id,meta_key,meta_value) VALUES(376, 'wp_user_level', 10); ``` Then I cleared my browser cookies and logged in again, but when I tried to navigate to `http://localhost/wp-admin` I still got "You do not have sufficient permissions to access this page." I even went so far as to delete my APC cache files and reload Nginx and PHP-FPM, which also didn't change anything. Does anyone know of anything else to try?

Original source