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 6131 in file /home1/zzz/public_html/wp-includes/functions.php
Profiler (0 ms)
No entries found.
SQL (33 queries | 32.09 ms)
0.4060 
SELECT option_value 
FROM wp_options 
WHERE option_name = 'GOTMLS_nonce_array' 
LIMIT 1
0.2229 
SELECT option_value 
FROM wp_options 
WHERE option_name = 'GOTMLS_definitions_array' 
LIMIT 1
1.0300 
SELECT * 
FROM `wp_posts` 
WHERE post_type = 'gotmls_results' 
AND post_name = '4d708a6a30a9a6d718df1340ae163f9e'
0.2899 
SELECT option_value 
FROM wp_options 
WHERE option_name = 'gzipcompression' 
LIMIT 1
0.3951 
SELECT option_value 
FROM wp_options 
WHERE option_name = 'rsssl_encryption_keys_set' 
LIMIT 1
0.3171 
SELECT option_value 
FROM wp_options 
WHERE option_name = 'rsssl_le_certificate_generated_by_rsssl' 
LIMIT 1
0.3541 
SELECT option_value 
FROM wp_options 
WHERE option_name = 'rsssl_ssl_activation_active' 
LIMIT 1
0.4699 
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.3409 
SELECT option_value 
FROM wp_options 
WHERE option_name = 'preload_cache_counter' 
LIMIT 1
0.9720 
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.8378 
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
12.3239 
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.7210 
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)
0.5960 
SELECT post_id, meta_key, meta_value 
FROM wp_postmeta 
WHERE post_id IN (1654) 
ORDER BY meta_id ASC
0.2799 
SELECT option_value 
FROM wp_options 
WHERE option_name = 'mwp_communication_key' 
LIMIT 1
0.2170 
SELECT option_value 
FROM wp_options 
WHERE option_name = 'mwp_communication_keys' 
LIMIT 1
0.2871 
SELECT option_value 
FROM wp_options 
WHERE option_name = 'can_compress_scripts' 
LIMIT 1
0.4849 
SELECT * 
FROM wp_posts 
WHERE ID = 1716 
LIMIT 1
0.5779 
SELECT option_value 
FROM wp_options 
WHERE option_name = 'https_migration_required' 
LIMIT 1
0.2630 
SELECT option_value 
FROM wp_options 
WHERE option_name = 'site_logo' 
LIMIT 1
0.4568 
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.4322 
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.7579 
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.3800 
SELECT wp_posts.* 
FROM wp_posts 
WHERE ID IN (1542,1534,1579,1544)
0.4389 
SELECT post_id, meta_key, meta_value 
FROM wp_postmeta 
WHERE post_id IN (1542,1534,1579,1544) 
ORDER BY meta_id ASC
0.8051 
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.7860 
SELECT user_id, meta_key, meta_value 
FROM wp_usermeta 
WHERE user_id IN (1) 
ORDER BY umeta_id ASC
0.4981 
SELECT * 
FROM wp_users 
WHERE ID IN (1)
1.2431 
SELECT p.ID 
FROM wp_posts AS p 
WHERE (p.post_date < '2014-11-06 15:30:08' OR (p.post_date = '2014-11-06 15:30:08' 
AND p.ID < 1654)) 
AND p.post_type = 'post' 
AND p.post_status = 'publish' 
ORDER BY p.post_date DESC, p.ID DESC 
LIMIT 1
0.6189 
SELECT * 
FROM wp_posts 
WHERE ID = 1652 
LIMIT 1
0.8299 
SELECT p.ID 
FROM wp_posts AS p 
WHERE (p.post_date > '2014-11-06 15:30:08' OR (p.post_date = '2014-11-06 15:30:08' 
AND p.ID > 1654)) 
AND p.post_type = 'post' 
AND p.post_status = 'publish' 
ORDER BY p.post_date ASC, p.ID ASC 
LIMIT 1
0.6199 
SELECT * 
FROM wp_posts 
WHERE ID = 1656 
LIMIT 1
0.8368 
SELECT SQL_CALC_FOUND_ROWS wp_comments.comment_ID 
FROM wp_comments 
WHERE ( comment_approved = '1' ) 
AND comment_post_ID = 1654 
AND comment_type NOT IN ('note') 
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' => 'aau7U1cc7-vkWB1KM1NWMAAAUzc',
  'REDIRECT_QS_ConnectionId' => '177286229149479503899481',
  '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' => '7',
  'REDIRECT_H2_STREAM_TAG' => '899481-743-7',
  'REDIRECT_STATUS' => '200',
  'UNIQUE_ID' => 'aau7U1cc7-vkWB1KM1NWMAAAUzc',
  'QS_ConnectionId' => '177286229149479503899481',
  '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' => '7',
  'H2_STREAM_TAG' => '899481-743-7',
  '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' => '61260',
  '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' => 1772862291.51196193695068359375,
  'REQUEST_TIME' => 1772862291,
  'argv' => 
  array (
  ),
  'argc' => 0,
);

Close