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 (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 | 15.87 ms)
0.2980 
SELECT option_value 
FROM wp_options 
WHERE option_name = 'GOTMLS_nonce_array' 
LIMIT 1
0.1991 
SELECT option_value 
FROM wp_options 
WHERE option_name = 'GOTMLS_definitions_array' 
LIMIT 1
0.4630 
SELECT * 
FROM `wp_posts` 
WHERE post_type = 'gotmls_results' 
AND post_name = '745f860730d1814e1aa34184aa17f593'
0.1669 
SELECT option_value 
FROM wp_options 
WHERE option_name = 'gzipcompression' 
LIMIT 1
0.2079 
SELECT option_value 
FROM wp_options 
WHERE option_name = 'rsssl_encryption_keys_set' 
LIMIT 1
0.1769 
SELECT option_value 
FROM wp_options 
WHERE option_name = 'rsssl_le_certificate_generated_by_rsssl' 
LIMIT 1
0.1299 
SELECT option_value 
FROM wp_options 
WHERE option_name = 'rsssl_ssl_activation_active' 
LIMIT 1
0.4210 
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.4220 
SELECT option_value 
FROM wp_options 
WHERE option_name = 'preload_cache_counter' 
LIMIT 1
0.6480 
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.4611 
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.5140 
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.3290 
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.1562 
SELECT post_id, meta_key, meta_value 
FROM wp_postmeta 
WHERE post_id IN (1620) 
ORDER BY meta_id ASC
0.1471 
SELECT option_value 
FROM wp_options 
WHERE option_name = 'mwp_communication_key' 
LIMIT 1
0.1290 
SELECT option_value 
FROM wp_options 
WHERE option_name = 'mwp_communication_keys' 
LIMIT 1
0.3738 
SELECT option_value 
FROM wp_options 
WHERE option_name = 'can_compress_scripts' 
LIMIT 1
0.4449 
SELECT * 
FROM wp_posts 
WHERE ID = 1716 
LIMIT 1
0.2220 
SELECT option_value 
FROM wp_options 
WHERE option_name = 'https_migration_required' 
LIMIT 1
0.1259 
SELECT option_value 
FROM wp_options 
WHERE option_name = 'site_logo' 
LIMIT 1
0.3340 
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
0.7710 
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.4361 
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.2010 
SELECT wp_posts.* 
FROM wp_posts 
WHERE ID IN (1542,1534,1579,1544)
0.2310 
SELECT post_id, meta_key, meta_value 
FROM wp_postmeta 
WHERE post_id IN (1542,1534,1579,1544) 
ORDER BY meta_id ASC
0.3991 
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.6452 
SELECT user_id, meta_key, meta_value 
FROM wp_usermeta 
WHERE user_id IN (1) 
ORDER BY umeta_id ASC
0.1810 
SELECT * 
FROM wp_users 
WHERE ID IN (1)
4.8339 
SELECT p.ID 
FROM wp_posts AS p 
WHERE (p.post_date < '2014-05-29 12:05:35' OR (p.post_date = '2014-05-29 12:05:35' 
AND p.ID < 1620)) 
AND p.post_type = 'post' 
AND p.post_status = 'publish' 
ORDER BY p.post_date DESC, p.ID DESC 
LIMIT 1
0.7060 
SELECT * 
FROM wp_posts 
WHERE ID = 1615 
LIMIT 1
0.4790 
SELECT p.ID 
FROM wp_posts AS p 
WHERE (p.post_date > '2014-05-29 12:05:35' OR (p.post_date = '2014-05-29 12:05:35' 
AND p.ID > 1620)) 
AND p.post_type = 'post' 
AND p.post_status = 'publish' 
ORDER BY p.post_date ASC, p.ID ASC 
LIMIT 1
0.1400 
SELECT * 
FROM wp_posts 
WHERE ID = 1622 
LIMIT 1
0.4799 
SELECT SQL_CALC_FOUND_ROWS wp_comments.comment_ID 
FROM wp_comments 
WHERE ( comment_approved = '1' ) 
AND comment_post_ID = 1620 
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/',
  '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=1620',
  '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' => 'aavOm85JkDjJoi7Ri9yxwQAAEEE',
  'REDIRECT_QS_ConnectionId' => '17728672279061276167235',
  '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' => '53',
  'REDIRECT_H2_STREAM_TAG' => '67235-24-53',
  'REDIRECT_STATUS' => '200',
  'UNIQUE_ID' => 'aavOm85JkDjJoi7Ri9yxwQAAEEE',
  'QS_ConnectionId' => '17728672279061276167235',
  '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' => '53',
  'H2_STREAM_TAG' => '67235-24-53',
  '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/',
  'SERVER_PROTOCOL' => 'HTTP/2.0',
  'REQUEST_METHOD' => 'GET',
  'QUERY_STRING' => '',
  'SCRIPT_NAME' => '/index.php',
  'PHP_SELF' => '/index.php',
  'REQUEST_TIME_FLOAT' => 1772867227.917850017547607421875,
  'REQUEST_TIME' => 1772867227,
  'argv' => 
  array (
  ),
  'argc' => 0,
);

Close