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 | 13.41 ms)
0.2270 
SELECT option_value 
FROM wp_options 
WHERE option_name = 'GOTMLS_nonce_array' 
LIMIT 1
0.1459 
SELECT option_value 
FROM wp_options 
WHERE option_name = 'GOTMLS_definitions_array' 
LIMIT 1
0.4261 
SELECT * 
FROM `wp_posts` 
WHERE post_type = 'gotmls_results' 
AND post_name = 'a6c7f11ac8dbf3657d20b1c0f09e2337'
0.1659 
SELECT option_value 
FROM wp_options 
WHERE option_name = 'gzipcompression' 
LIMIT 1
0.2880 
SELECT option_value 
FROM wp_options 
WHERE option_name = 'rsssl_encryption_keys_set' 
LIMIT 1
0.1581 
SELECT option_value 
FROM wp_options 
WHERE option_name = 'rsssl_le_certificate_generated_by_rsssl' 
LIMIT 1
0.1230 
SELECT option_value 
FROM wp_options 
WHERE option_name = 'rsssl_ssl_activation_active' 
LIMIT 1
0.5081 
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.2420 
SELECT option_value 
FROM wp_options 
WHERE option_name = 'preload_cache_counter' 
LIMIT 1
0.7069 
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.5620 
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
0.7579 
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.4120 
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.2282 
SELECT post_id, meta_key, meta_value 
FROM wp_postmeta 
WHERE post_id IN (1654) 
ORDER BY meta_id ASC
0.2131 
SELECT option_value 
FROM wp_options 
WHERE option_name = 'mwp_communication_key' 
LIMIT 1
0.1562 
SELECT option_value 
FROM wp_options 
WHERE option_name = 'mwp_communication_keys' 
LIMIT 1
0.2241 
SELECT option_value 
FROM wp_options 
WHERE option_name = 'can_compress_scripts' 
LIMIT 1
0.4959 
SELECT * 
FROM wp_posts 
WHERE ID = 1716 
LIMIT 1
0.4020 
SELECT option_value 
FROM wp_options 
WHERE option_name = 'https_migration_required' 
LIMIT 1
0.5090 
SELECT option_value 
FROM wp_options 
WHERE option_name = 'site_logo' 
LIMIT 1
0.4711 
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.0660 
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.6530 
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.4890 
SELECT wp_posts.* 
FROM wp_posts 
WHERE ID IN (1542,1534,1579,1544)
0.3760 
SELECT post_id, meta_key, meta_value 
FROM wp_postmeta 
WHERE post_id IN (1542,1534,1579,1544) 
ORDER BY meta_id ASC
0.4420 
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
0.5779 
SELECT user_id, meta_key, meta_value 
FROM wp_usermeta 
WHERE user_id IN (1) 
ORDER BY umeta_id ASC
0.2329 
SELECT * 
FROM wp_users 
WHERE ID IN (1)
0.5529 
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.1700 
SELECT * 
FROM wp_posts 
WHERE ID = 1652 
LIMIT 1
0.9251 
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.1831 
SELECT * 
FROM wp_posts 
WHERE ID = 1656 
LIMIT 1
0.3181 
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/?p=1654',
  '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' => 'aavOms5JkDjJoi7Ri9yxoAAAECc',
  'REDIRECT_QS_ConnectionId' => '17728672268415613567235',
  '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' => '67235-24-7',
  'REDIRECT_STATUS' => '200',
  'UNIQUE_ID' => 'aavOms5JkDjJoi7Ri9yxoAAAECc',
  'QS_ConnectionId' => '17728672268415613567235',
  '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' => '67235-24-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' => '25091',
  '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' => 1772867226.85513591766357421875,
  'REQUEST_TIME' => 1772867226,
  'argv' => 
  array (
  ),
  'argc' => 0,
);

Close