Create an admin user in the WordPress database

Generic selectors
Exact matches only
Search in title
Search in content
Filter by Categories
Account Management Help
add photos, video and audio
Add-on features and social media
Advanced campaign settings
All about analytics
All about images
Basic steps
Configure the Web Application Firewall (WAF)
Connect my Calendar and Online Storage to Workspace
contact support
copy files to my site
Create my email address
Customize campaign
Discover domains
discover linux hosting with cPanel
Discover Microsoft 365
Discover Online Storage
Discover Workspace Email
edit content
Email Marketing demo
expand your site with sections and pages
Explore email add-ons
Explore my account
Find server and port settings (IMAP/POP)
fine tune my website
get social
Get started with SSL certificates
Get the most out of Microsoft 365
help my site get found and monitor my metrics
Hosting & Servers
keep my account secure
Keep my email secure
know your privacy rights
Manage your SSL certificate
Managed WordPress
Manual email configuration
Migrate and export my emails
My email account isn’t working (troubleshooting)
nameservers and DNS
online store
parking, forwarding and monetizing
privacy and protection
publish my site
Quick Shopping Cart
Renew my products and services
Set up a campaign
Set up email on my devices
set up my payment methods
Set up my Workspace Email account
start with the basics
Stay productive anywhere with Office apps
Streamline email tasks to help my business
transfer between accounts
transfer between registrars
Troubleshoot email and email setup
Upgrade and renewal options for email
Web & Classic Hosting
Website backups
Website Builder 7
Website Builder version 6
Website Security and Backups
work with databases
work with delegates
working with blogs

You can create a new WordPress admin user from within the database. Use this method if your original admin user was corrupted or deleted.

  1. Log into phpMyAdmin (cPanel / Plesk / Web Hosting / Managed WordPress). 

Note: If you’re using cPanel Hosting, you must select the database for your WordPress site in the left column before continuing to the next step.

  1. In the left menu, select the wp_users table.
  2. Select Insert.

Enter the following:

FieldWhat it is…
IDAny number that isn’t already used by another user
user_loginUsername for accessing the WordPress dashboard
user_passPassword for this user Note: Make sure to select MD5 in the functions menu.
user_nicenameThe nickname for this user
user_emailEmail address for this user
user_registeredDate and time this user was registered
user_statusSet this to 0
display_nameName that will display for this user
  1. Select Go.
  2. Select the wp_usermeta table.
  3. Select Insert.
FieldWhatit is…
user_idEnter the ID from step 4
meta_keyEnter wp_capabilities Note: For Managed WordPress accounts or custom database table prefixes, include the prefix (e.g. wp_coolPrefix_capabilities).
Enter the following: a:1:{s:13:”administrator”;s:1:”1″;}
  1. Select Go.
  2. Select the Insert tab again.
FieldWhat it is…
user_idEnter the ID from step 4
meta_keyEnter wp_user_level Note: For Managed WordPress accounts or custom database table prefixes, include the prefix (e.g. wp_coolPrefix_user_level).
meta_valueEnter the number 10
  1. Select Go.

The admin user is now ready to log n with their username and password.

More Info

Changing the currency for the products.

Prices shown in US Dollars. You can convert to your own currency after selecting a product.