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 November 6, 2014 by zzz_zwp

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

This entry was posted in Uncategorized and tagged manually-add-user, users, wordpress by zzz_zwp. Bookmark the permalink.
© zzzzzzzzz
Toggle Console (1)
Unknown 
Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the gotmls domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) on line 6121 in file /home1/zzz/public_html/wp-includes/functions.php
Profiler (0 ms)
No entries found.
SQL (30 queries | 23.35 ms)
0.6258 
SELECT option_value 
FROM wp_options 
WHERE option_name = 'GOTMLS_nonce_array' 
LIMIT 1
0.4461 
SELECT option_value 
FROM wp_options 
WHERE option_name = 'GOTMLS_definitions_array' 
LIMIT 1
0.6132 
SELECT option_value 
FROM wp_options 
WHERE option_name = 'GOTMLS_scan_log/216.73.216.148/1749990959.7119' 
LIMIT 1
0.5350 
SELECT option_value 
FROM wp_options 
WHERE option_name = 'gzipcompression' 
LIMIT 1
0.5641 
SELECT option_value 
FROM wp_options 
WHERE option_name = 'rsssl_encryption_keys_set' 
LIMIT 1
0.3300 
SELECT option_value 
FROM wp_options 
WHERE option_name = 'rsssl_le_certificate_generated_by_rsssl' 
LIMIT 1
0.4539 
SELECT option_value 
FROM wp_options 
WHERE option_name = 'rsssl_ssl_activation_active' 
LIMIT 1
0.5980 
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.3662 
SELECT option_value 
FROM wp_options 
WHERE option_name = 'preload_cache_counter' 
LIMIT 1
0.7520 
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-2') 
AND post_type IN ('page','attachment')
0.5591 
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-2' 
AND wp_posts.post_type = 'post' 
ORDER BY wp_posts.post_date DESC
1.1020 
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 (1654) 
ORDER BY t.name ASC
0.6709 
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 (463,1,462,200)
4.6339 
SELECT post_id, meta_key, meta_value 
FROM wp_postmeta 
WHERE post_id IN (1654) 
ORDER BY meta_id ASC
0.5281 
SELECT * 
FROM wp_posts 
WHERE ID = 1716 
LIMIT 1
0.1891 
SELECT option_value 
FROM wp_options 
WHERE option_name = 'https_migration_required' 
LIMIT 1
0.1700 
SELECT option_value 
FROM wp_options 
WHERE option_name = 'site_logo' 
LIMIT 1
0.3531 
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.0839 
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.8450 
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.6020 
SELECT wp_posts.* 
FROM wp_posts 
WHERE ID IN (1542,1534,1579,1544)
0.5419 
SELECT post_id, meta_key, meta_value 
FROM wp_postmeta 
WHERE post_id IN (1542,1534,1579,1544) 
ORDER BY meta_id ASC
1.0309 
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 (1654) 
ORDER BY t.name ASC
1.2071 
SELECT user_id, meta_key, meta_value 
FROM wp_usermeta 
WHERE user_id IN (1) 
ORDER BY umeta_id ASC
0.7401 
SELECT * 
FROM wp_users 
WHERE ID IN (1)
0.8171 
SELECT p.ID 
FROM wp_posts AS p 
WHERE p.post_date < '2014-11-06 15:30:08' 
AND p.post_type = 'post' 
AND p.post_status = 'publish' 
ORDER BY p.post_date DESC 
LIMIT 1
0.6721 
SELECT * 
FROM wp_posts 
WHERE ID = 1652 
LIMIT 1
0.7501 
SELECT p.ID 
FROM wp_posts AS p 
WHERE p.post_date > '2014-11-06 15:30:08' 
AND p.post_type = 'post' 
AND p.post_status = 'publish' 
ORDER BY p.post_date ASC 
LIMIT 1
0.6402 
SELECT * 
FROM wp_posts 
WHERE ID = 1656 
LIMIT 1
0.9251 
SELECT SQL_CALC_FOUND_ROWS wp_comments.comment_ID 
FROM wp_comments 
WHERE ( comment_approved = '1' ) 
AND comment_post_ID = 1654 
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-2/',
  '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://www.zzzzzzzzz.net/how-to-add-an-admin-user-to-the-wordpress-database-via-mysql-2',
  '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' => 'aE6-LxScDv1UyII5hm7avQAAkT8',
  'REDIRECT_QS_ConnectionId' => '174999095967682783950396',
  'REDIRECT_SCRIPT_URL' => '/how-to-add-an-admin-user-to-the-wordpress-database-via-mysql-2/',
  'REDIRECT_SCRIPT_URI' => 'https://www.zzzzzzzzz.net/how-to-add-an-admin-user-to-the-wordpress-database-via-mysql-2/',
  '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' => '5',
  'REDIRECT_H2_STREAM_TAG' => '950396-1017-5',
  'REDIRECT_STATUS' => '200',
  'UNIQUE_ID' => 'aE6-LxScDv1UyII5hm7avQAAkT8',
  'QS_ConnectionId' => '174999095967682783950396',
  'SCRIPT_URL' => '/how-to-add-an-admin-user-to-the-wordpress-database-via-mysql-2/',
  'SCRIPT_URI' => 'https://www.zzzzzzzzz.net/how-to-add-an-admin-user-to-the-wordpress-database-via-mysql-2/',
  'HTTPS' => 'on',
  'SSL_TLS_SNI' => 'www.zzzzzzzzz.net',
  'HTTP2' => 'on',
  'H2PUSH' => 'off',
  'H2_PUSH' => 'off',
  'H2_PUSHED' => '',
  'H2_PUSHED_ON' => '',
  'H2_STREAM_ID' => '5',
  'H2_STREAM_TAG' => '950396-1017-5',
  'SERVER_SIGNATURE' => '',
  'SERVER_NAME' => 'www.zzzzzzzzz.net',
  'SERVER_ADDR' => '192.185.137.117',
  'SERVER_PORT' => '443',
  'REMOTE_ADDR' => '216.73.216.148',
  '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' => '62262',
  'REDIRECT_URL' => '/how-to-add-an-admin-user-to-the-wordpress-database-via-mysql-2/',
  'SERVER_PROTOCOL' => 'HTTP/2.0',
  'REQUEST_METHOD' => 'GET',
  'QUERY_STRING' => '',
  'SCRIPT_NAME' => '/index.php',
  'PHP_SELF' => '/index.php',
  'REQUEST_TIME_FLOAT' => 1749990959.6888630390167236328125,
  'REQUEST_TIME' => 1749990959,
  'argv' => 
  array (
  ),
  'argc' => 0,
);

Close