Making someone a WordPress administrator using PhpMyAdmin

You actually want to look in the wp_usermeta table. Once in there, look for the entry that has ‘wp_user_level‘ in it’s ‘meta_key’ column and has the matching ‘user_id’ that you would like to update. Then change that ‘meta_value’ to 9 or 10.

It is also required to update the ‘wp_capabilities‘ meta_key value to ‘a:1:{s:13:"administrator";s:1:"1";}‘

Link to current documentation:

http://codex.wordpress.org/Roles_and_Capabilities#User_Levels

Related Posts:

  1. http://localhost/phpMyAdmin/ unable to connect
  2. phpMyAdmin Error: The mbstring extension is missing. Please check your PHP configuration
  3. ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)
  4. mysql said: Cannot connect: invalid settings. xampp
  5. This table does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available
  6. Delete a database in phpMyAdmin
  7. PHPMyAdmin Default login password
  8. wamp server mysql user id and password
  9. phpmyadmin “Not Found” after install on Apache, Ubuntu
  10. Delete a database in phpMyAdmin
  11. Why am I unable to login to Dashboard after adding myself to admin via phpMyAdmin?
  12. Resetting menu_order to 0 for posts in PHPmyAdmin?
  13. phpMyAdmin displays error when importing database 2
  14. oembed_cache SPAM problem [closed]
  15. Delete all pages (thousands) except a few by their IDs
  16. Recovering a wordpress blog that got corrupted
  17. Importing posts content from csv
  18. duplicate wordpress site on same bdd
  19. I can not access my local PhpMyAdmin control panel
  20. wp_login.php redirects to old domain
  21. Strings from database are not shown correctly
  22. How to change wordpress adminstrator user ‘s ID from 1 to 0?
  23. WordPress database defragmentation
  24. Cannot login to WordPress admin after update
  25. mysqli_real_connect(): (HY000/2002): No such file or directory
  26. MySQL Error #1133 – Can’t find any matching row in the user table
  27. phpMyAdmin ERROR: mysqli_real_connect(): (HY000/1045): Access denied for user ‘pma’@’localhost’ (using password: NO)
  28. How to create a foreign key in phpmyadmin
  29. MySQL: Can’t create table (errno: 150)
  30. MySQL: How to reset or change the MySQL root password?
  31. Moving WordPress from MAMP to WAMP, can’t access pages
  32. Moving WordPress from MAMP to WAMP, can’t access pages
  33. What specific database privileges does WordPress need?
  34. “#1067 – Invalid default value for ‘post_date'” when trying to reset AI after backup
  35. How to delete users with no order history through phpmyadmin sql?
  36. POSTS list in WordPress by views
  37. How to copy post titles to post slug in phpmyadmin
  38. Delete all post meta except featured image
  39. Export only pages and posts with mysql dump
  40. How to do a MySQL dump from production site without using a search and replace script for local development?
  41. How to Move Local Singlesite Database to Remote Multsite Database?
  42. Query to change custom post type with specific category
  43. $wpdb->query() vs. $wpdb->get_results() vs. phpMyAdmin
  44. Duplicate posts when posting nulls in records in phpMyAdmin [closed]
  45. Double domain name in category URL-s
  46. Can’t find my wordpress DB in phpmyadmin
  47. WordPress database import: Row size too large
  48. Query to import data from one MultiSite table to another (pages/sub-pages)
  49. How to make custom column Admin>Users sortable?
  50. How to display data from custom table in wordpress phpmyadmin
  51. Plugin: register_deactivation_hook works perfectly well, while register_activation_hook suddenly stopped working
  52. WordPress Database Huge wp_usermeta Table
  53. Lamp stack not supporting phpmyadmin? [closed]
  54. Will changing the folder name two directories above a fresh wordpress installation break the site?
  55. MySql query to get posts with all meta and terms
  56. Restose content from revisions – sql query
  57. $wpdb to insert html form information
  58. Better way to migrate to server?
  59. I want to create a 300 multi-site wordpress network using subdomains
  60. How do i edit the plugin files in DataBase via phpMyAdmin?
  61. Update a buggy installation
  62. How to migrate a database from a server to another
  63. Broken wordpress site, non-working links and no access to wp-admin page
  64. Live to Local on MAMP, not working, outputting functions.php code
  65. Getting Error Trying to Create Table
  66. WordPress can I manually add columns in users table and display it in the default manage user plugin and registration form? [closed]
  67. Unable to install and upload theme due to php.ini file [closed]
  68. How to periodically roll back WordPress to a fixed point in time?
  69. Change WordPress Multisite Domain
  70. phpMyAdmin error #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’
  71. How Do I Delete WordPress Posts Older Than 400 Days, From A WordPress Category
  72. List users with the most posts in the last 30 days
  73. wp_option table error while importing
  74. How to track who has deleted files
  75. Installing local to live WP into subdirectory
  76. How can I get posts from 9/13/11 to today with SQL? [closed]
  77. Change word in woocommerce product category custom field
  78. Mysql Server keeps crashing
  79. How to change my 3000 Published post status to Draft using PHPMyAdmin
  80. Error establishing a database connection (Set-up locally)
  81. Delete all users with Editor role and their content mysql
  82. I imported an restore an database and It shows #1067 – Invalid default value for ‘user_registered’
  83. Updating user meta adds string count to value?
  84. I need to find posts that contain YouTube links without http:// or https:// prefix and add http:// to all of them
  85. Migrating meta_key and meta_value from old theme to new one
  86. Can I disable auto increment of WordPress Posts Database to utilize previously deleted records?
  87. WordPress PHP version
  88. Help locating old custom_css in PHP MyAdmin
  89. SQL query to bulk change short code in all posts
  90. Duplicate database to roll back theme & content changes
  91. An SQL query to find orphaned image attachments and their meta
  92. Change Custom Post Type to Post + Category
  93. Adding wordpress posts using phpmyadmin
  94. How to retrieve user data based on role using SQL?
  95. Changing WordPress author name in database
  96. Missing latest posts and options after DB migration via phpMyAdmin
  97. Options table – where does my values go?
  98. I would like to import two columns into WordPress
  99. Need SQL query to find&replace image URL
  100. How to run site locally after downloading database

Leave a Comment