z z z z z z z z z

z z z z z z z z z

Main menu

Skip to primary content
Skip to secondary content
  • Home
  • Bookmarklet Generator
  • Business Name Generator
  • What is my IP address?
  • Whois Lookup

Post navigation

← Previous Next →

How to Add an Admin User to the WordPress Database via MySQL

Posted on May 29, 2014 by zzz_zwp

Make sure to use the proper prefix for ‘wp_’ if you have a custom database prefix and to follow the existing user capabilities values when manually adding a user to WordPress.

How to Add an Admin User to the WordPress Database via MySQL.

This entry was posted in Uncategorized and tagged manual-add-user, mysql, wordpress by zzz_zwp. Bookmark the permalink.
© zzzzzzzzz
Toggle Console (0)
No entries found.
Profiler (0 ms)
No entries found.
SQL (30 queries | 28.34 ms)
2.1188 
SELECT option_value 
FROM wp_options 
WHERE option_name = 'GOTMLS_nonce_array' 
LIMIT 1
0.5898 
SELECT option_value 
FROM wp_options 
WHERE option_name = 'GOTMLS_definitions_array' 
LIMIT 1
3.0830 
SELECT option_value 
FROM wp_options 
WHERE option_name = 'GOTMLS_scan_log/3.23.92.50/1737176593.0737' 
LIMIT 1
3.5329 
SELECT option_value 
FROM wp_options 
WHERE option_name = 'gzipcompression' 
LIMIT 1
3.2198 
SELECT option_value 
FROM wp_options 
WHERE option_name = 'rsssl_encryption_keys_set' 
LIMIT 1
0.4508 
SELECT option_value 
FROM wp_options 
WHERE option_name = 'rsssl_le_certificate_generated_by_rsssl' 
LIMIT 1
2.0201 
SELECT option_value 
FROM wp_options 
WHERE option_name = 'rsssl_ssl_activation_active' 
LIMIT 1
0.5300 
SELECT option_name, option_value 
FROM wp_options 
WHERE option_name IN ('_site_transient_wp_theme_files_patterns-521ceac6f7ea50d1f2c96a08a1af8fc4','_site_transient_timeout_wp_theme_files_patterns-521ceac6f7ea50d1f2c96a08a1af8fc4')
0.3731 
SELECT option_value 
FROM wp_options 
WHERE option_name = 'preload_cache_counter' 
LIMIT 1
0.6011 
SELECT ID, post_name, post_parent, post_type 
FROM wp_posts 
WHERE post_name IN ('how-to-add-an-admin-user-to-the-wordpress-database-via-mysql') 
AND post_type IN ('page','attachment')
0.6430 
SELECT wp_posts.* 
FROM wp_posts 
WHERE 1=1 
AND wp_posts.post_name = 'how-to-add-an-admin-user-to-the-wordpress-database-via-mysql' 
AND wp_posts.post_type = 'post' 
ORDER BY wp_posts.post_date DESC
0.9580 
SELECT DISTINCT t.term_id, tr.object_id 
FROM wp_terms AS t 
INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id 
INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id 
WHERE tt.taxonomy IN ('category', 'post_tag', 'post_format') 
AND tr.object_id IN (1620) 
ORDER BY t.name ASC
0.5150 
SELECT t.*, tt.* 
FROM wp_terms AS t 
INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id 
WHERE t.term_id IN (439,67,1,200)
0.4711 
SELECT post_id, meta_key, meta_value 
FROM wp_postmeta 
WHERE post_id IN (1620) 
ORDER BY meta_id ASC
0.5929 
SELECT * 
FROM wp_posts 
WHERE ID = 1716 
LIMIT 1
0.3629 
SELECT option_value 
FROM wp_options 
WHERE option_name = 'https_migration_required' 
LIMIT 1
0.2880 
SELECT option_value 
FROM wp_options 
WHERE option_name = 'site_logo' 
LIMIT 1
0.4039 
SELECT t.*, tt.* 
FROM wp_terms AS t 
INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id 
WHERE t.term_id = 468
1.3571 
SELECT wp_posts.* 
FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) 
WHERE 1=1 
AND ( wp_term_relationships.term_taxonomy_id IN (468) ) 
AND wp_posts.post_type = 'nav_menu_item' 
AND ((wp_posts.post_status = 'publish')) 
GROUP BY wp_posts.ID 
ORDER BY wp_posts.menu_order ASC
0.7660 
SELECT post_id, meta_key, meta_value 
FROM wp_postmeta 
WHERE post_id IN (1670,1671,1672,1681,1682) 
ORDER BY meta_id ASC
0.4058 
SELECT wp_posts.* 
FROM wp_posts 
WHERE ID IN (1542,1534,1579,1544)
0.4950 
SELECT post_id, meta_key, meta_value 
FROM wp_postmeta 
WHERE post_id IN (1542,1534,1579,1544) 
ORDER BY meta_id ASC
0.9332 
SELECT DISTINCT t.term_id 
FROM wp_terms AS t 
INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id 
INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id 
WHERE tt.taxonomy IN ('category') 
AND tr.object_id IN (1620) 
ORDER BY t.name ASC
0.9840 
SELECT user_id, meta_key, meta_value 
FROM wp_usermeta 
WHERE user_id IN (1) 
ORDER BY umeta_id ASC
0.3800 
SELECT * 
FROM wp_users 
WHERE ID IN (1)
0.5150 
SELECT p.ID 
FROM wp_posts AS p 
WHERE p.post_date < '2014-05-29 12:05:35' 
AND p.post_type = 'post' 
AND p.post_status = 'publish' 
ORDER BY p.post_date DESC 
LIMIT 1
0.5870 
SELECT * 
FROM wp_posts 
WHERE ID = 1615 
LIMIT 1
0.5391 
SELECT p.ID 
FROM wp_posts AS p 
WHERE p.post_date > '2014-05-29 12:05:35' 
AND p.post_type = 'post' 
AND p.post_status = 'publish' 
ORDER BY p.post_date ASC 
LIMIT 1
0.2551 
SELECT * 
FROM wp_posts 
WHERE ID = 1622 
LIMIT 1
0.3669 
SELECT SQL_CALC_FOUND_ROWS wp_comments.comment_ID 
FROM wp_comments 
WHERE ( comment_approved = '1' ) 
AND comment_post_ID = 1620 
AND comment_parent = 0 
ORDER BY wp_comments.comment_date_gmt ASC, wp_comments.comment_ID ASC
Templates 
[0] => themes/twentyeleven/inc/theme-options.php
[1] => themes/twentyeleven/inc/widgets.php
[2] => themes/twentyeleven/single.php
[3] => themes/twentyeleven/header.php
[4] => themes/twentyeleven/searchform.php
[5] => themes/twentyeleven/content-single.php
[6] => themes/twentyeleven/comments.php
[7] => themes/twentyeleven/footer.php
[8] => themes/twentyeleven/sidebar-footer.php
Globals 
$_GET = array (
);

$_POST = array (
);

$_COOKIE = array (
);

$_SESSION = array (
);

$_SERVER = array (
  'SERVER_SOFTWARE' => 'Apache',
  'REQUEST_URI' => '/how-to-add-an-admin-user-to-the-wordpress-database-via-mysql/',
  'LSPHP_ENABLE_USER_INI' => 'on',
  'PATH' => '/usr/local/bin:/usr/bin:/bin',
  'TEMP' => '/tmp',
  'TMP' => '/tmp',
  'TMPDIR' => '/tmp',
  'PWD' => '/',
  'HTTP_ACCEPT' => '*/*',
  'HTTP_ACCEPT_ENCODING' => 'gzip, br, zstd, deflate',
  'CONTENT_LENGTH' => '0',
  'HTTP_HOST' => 'www.zzzzzzzzz.net',
  'HTTP_REFERER' => 'https://zzzzzzzzz.net/how-to-add-an-admin-user-to-the-wordpress-database-via-mysql',
  'HTTP_USER_AGENT' => 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)',
  'HTTP_X_HTTPS' => '1',
  'REDIRECT_UNIQUE_ID' => 'Z4s2EVmltJhdOTxSeKNF1gAAU3M',
  'REDIRECT_QS_ConnectionId' => '173717659302375663919127',
  'REDIRECT_SCRIPT_URL' => '/how-to-add-an-admin-user-to-the-wordpress-database-via-mysql/',
  'REDIRECT_SCRIPT_URI' => 'https://www.zzzzzzzzz.net/how-to-add-an-admin-user-to-the-wordpress-database-via-mysql/',
  'REDIRECT_HTTPS' => 'on',
  'REDIRECT_SSL_TLS_SNI' => 'www.zzzzzzzzz.net',
  'REDIRECT_HTTP2' => 'on',
  'REDIRECT_H2PUSH' => 'off',
  'REDIRECT_H2_PUSH' => 'off',
  'REDIRECT_H2_PUSHED' => '',
  'REDIRECT_H2_PUSHED_ON' => '',
  'REDIRECT_H2_STREAM_ID' => '1',
  'REDIRECT_H2_STREAM_TAG' => '919127-785-1',
  'REDIRECT_STATUS' => '200',
  'UNIQUE_ID' => 'Z4s2EVmltJhdOTxSeKNF1gAAU3M',
  'QS_ConnectionId' => '173717659302375663919127',
  'SCRIPT_URL' => '/how-to-add-an-admin-user-to-the-wordpress-database-via-mysql/',
  'SCRIPT_URI' => 'https://www.zzzzzzzzz.net/how-to-add-an-admin-user-to-the-wordpress-database-via-mysql/',
  'HTTPS' => 'on',
  'SSL_TLS_SNI' => 'www.zzzzzzzzz.net',
  'HTTP2' => 'on',
  'H2PUSH' => 'off',
  'H2_PUSH' => 'off',
  'H2_PUSHED' => '',
  'H2_PUSHED_ON' => '',
  'H2_STREAM_ID' => '1',
  'H2_STREAM_TAG' => '919127-785-1',
  'SERVER_SIGNATURE' => '',
  'SERVER_NAME' => 'www.zzzzzzzzz.net',
  'SERVER_ADDR' => '192.185.137.117',
  'SERVER_PORT' => '443',
  'REMOTE_ADDR' => '3.23.92.50',
  'DOCUMENT_ROOT' => '/home1/zzz/public_html',
  'REQUEST_SCHEME' => 'https',
  'CONTEXT_PREFIX' => '',
  'CONTEXT_DOCUMENT_ROOT' => '/home1/zzz/public_html',
  'SERVER_ADMIN' => 'webmaster@zzzzzzzzz.net',
  'SCRIPT_FILENAME' => '/home1/zzz/public_html/index.php',
  'REMOTE_PORT' => '38370',
  'REDIRECT_URL' => '/how-to-add-an-admin-user-to-the-wordpress-database-via-mysql/',
  'SERVER_PROTOCOL' => 'HTTP/2.0',
  'REQUEST_METHOD' => 'GET',
  'QUERY_STRING' => '',
  'SCRIPT_NAME' => '/index.php',
  'PHP_SELF' => '/index.php',
  'REQUEST_TIME_FLOAT' => 1737176593.042026996612548828125,
  'REQUEST_TIME' => 1737176593,
  'argv' => 
  array (
  ),
  'argc' => 0,
);

Close