How to Create a Admin User for A WordPress Site via MySQL (PHPMyAdmin)?

You need to run those below queries-

INSERT INTO `your-wp-database`.`wp_users` (`ID`, `user_login`, `user_pass`, `user_nicename`, `user_email`, `user_status`, `display_name`) VALUES ('1000', 'your_username', MD5('Str0ngPa55!'), 'your_username', '[email protected]', '0', 'User Display Name');

INSERT INTO `your-wp-database`.`wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, '1000', 'wp_capabilities', 'a:1:{s:13:"administrator";b:1;}');

INSERT INTO `your-wp-database`.`wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, '1000', 'wp_user_level', '10');

But notice here your-wp-database is the name of your WordPress database, 1000 is your newly created user’s ID, [email protected] is the user email, the your_username is your user’s username, User Display Name is your newly created user’s display name and lastly Str0ngPa55! is the password of your newly created user.

Related Posts:

  1. Setting up foreign keys in phpMyAdmin?
  2. #1045 – Access denied for user ‘root’@’localhost’ (using password: YES)
  3. MySQL Error #1133 – Can’t find any matching row in the user table
  4. phpmyadmin #1045 Cannot log in to the MySQL server. after installing mysql command line client
  5. How to create a foreign key in phpmyadmin
  6. importing a CSV into phpmyadmin
  7. MySQL said: Documentation #1045 – Access denied for user ‘root’@’localhost’ (using password: NO)
  8. What specific database privileges does WordPress need?
  9. “#1067 – Invalid default value for ‘post_date'” when trying to reset AI after backup
  10. How to copy post titles to post slug in phpmyadmin
  11. How to do a MySQL dump from production site without using a search and replace script for local development?
  12. SQL error #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’ [closed]
  13. Set meta_key and meta_value for all registered user in wordpress using sql query [closed]
  14. Can’t find my wordpress DB in phpmyadmin
  15. Backing up and restoring multiple sites efficiently
  16. $wpdb to insert html form information
  17. Setting up WordPress Locally on WAMP for a new site (with one already)
  18. Getting Error Trying to Create Table
  19. Export Yoast Keywords from MySQL/phpMyAdmin
  20. Editing mysql tables/database with wordpress or other app/cms
  21. List users with the most posts in the last 30 days
  22. Export SQL query based on custom field?
  23. Mysql Server keeps crashing
  24. How to bulk delete a certain part of all wordpress posts
  25. When I add metadata, metavalue length is added in to the value in some cases
  26. WordPress fails to install with “Can’t Select Database” Error (WAMPServer)
  27. Find locations of all featured images of draft posts via SQL
  28. SQL query to change custom field in WordPress database
  29. Login issue in WordPress
  30. An SQL query to find orphaned image attachments and their meta
  31. cannot log in to the mysql server (wamp and wordpress)
  32. SQL command to export post_content from wp_posts using phpMyAdmin
  33. Need SQL query to find&replace image URL
  34. MySQL error 2006: mysql server has gone away
  35. “INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE”
  36. #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
  37. what does “/index.php?admin/admin_dashboard” in my url mean
  38. How to join two tables by multiple columns in SQL?
  39. How to get size of mysql database?
  40. SQL – Update multiple records in one query
  41. MySQL Error 1093 – Can’t specify target table for update in FROM clause
  42. mysqladmin: connect to server at ‘localhost’ failed
  43. mysql update multiple columns with same now()
  44. Usage of MySQL’s “IF EXISTS”
  45. Generating a random & unique 8 character string using MySQL
  46. MySQL > Table doesn’t exist. But it does (or it should)
  47. Getting java.sql.SQLException: Operation not allowed after ResultSet closed
  48. mysql count duplicates
  49. Can’t create test file lower test start server mysql
  50. MySQL delete multiple rows in one query conditions unique to each row
  51. SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: Name or service not known
  52. CAST to DECIMAL in MySQL
  53. Failed to Connect to MySQL at localhost:3306 with user root
  54. Moving WordPress from MAMP to WAMP, can’t access pages
  55. How do you properly prepare a %LIKE% SQL statement?
  56. SQL query to update post_date (one post = one single date & time)
  57. Updating User Meta with SQL Query
  58. Delete all post meta except featured image
  59. If I consider changing my WordPress DB tables to InnoDB, will it have an effect on the way WordPress works?
  60. Database: Custom table: sprintf value for DateTime column
  61. Query to change custom post type with specific category
  62. What is the most secure way to set up the MySQL user in WPMU?
  63. Rewrite database urls
  64. writing inner join in wpdb
  65. How to get data from WordPress site sql file
  66. Unknown collation when I import a dump from an existing site into a development database?
  67. PHP script can’t connect to Database on port 3307
  68. WordPress with php5-fpm and nginx
  69. When WordPress Default table, Echo Success. When Plugin Table, Echo Blank
  70. How to translate this mySQL query to $wpdb query
  71. MySql query to get posts with all meta and terms
  72. Proper usage of $wpdb->update()?
  73. MySQL 5.5 upgrade ‘broke’ WordPress [closed]
  74. Separate DB by yearly archive of WordPress
  75. What should a WordPress developer know about MySQL? [closed]
  76. Copyright: Get first and last date of post type
  77. Update MySQL query so that it functions again
  78. Query posts by custom taxonomy and sort by post_modified
  79. WordPress $wpdb get posts from category and sort by custom meta
  80. Array Formation Issue
  81. How can I write a formal sql query to get data from a custom table
  82. Migration problems with mysql: Operation not allowed when innodb_forced_recovery > 0 [closed]
  83. WordPress $wpdb no result
  84. Delete all users with Editor role and their content mysql
  85. when using $wpdb sudden connection rejection without changing anything. Access denied, with errors from repair tool
  86. edit_user_created_user hook – using to update Groups
  87. Changes not being reflected on new server
  88. Mysql Error in querying form entries in Gravity Form plugin
  89. Improving performance of SQL sub-queries in WordPress
  90. Missing latest posts and options after DB migration via phpMyAdmin
  91. Saving custom term value to the database in new table
  92. MySQL errors after a WordPress clone
  93. MYSQL Join on meta key value?
  94. Woocommerce: Grab total revenue of a product over all orders
  95. Complicated MySQL Query
  96. problem with quotes on new post
  97. Why does the MySQL command line tool ignore the –port parameter?
  98. Postgres equivalent to MySQL’s \G?
  99. Changing host permissions for MySQL users
  100. Possible SQL injection. How to locate and fix?