Create an admin user in the WordPress database

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

  1. Sign in to phpMyAdmin.
  2. In phpMyAdmin, in the left-side menu, select the name of the database your site uses.
  3. From the left-side menu, look for the users table and select that table (select the text, not the checkbox). For example, this table might be called wp_users in your menu.
  4. From the top menu, select Insert.
  5. In the Value column, 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_registeredThe date and time this user was registered.
      user_statusSet this to 0.
      display_nameName that will display for this user.
  6. On the right, select Go.
  7. From the left-side menu, look for the usermeta table and select that table (select the text, not the checkbox). For example, this table might be called wp_usermeta in your menu.
  8. From the top menu, select Insert.
  9. In theΒ ValueΒ column, enter the following:
    • FieldWhat it is…
      user_idEnter the ID from step 4.
      meta_keyEnter wp_capabilities. Note: For Managed WordPress accounts or custom database table prefixes, replace wp_ with the correct prefix (such as coolPrefix_capabilities).
      meta_valueEnter the following: a:1:{s:13:”administrator”;s:1:”1″;}
  10. Select Go.
  11. Select the Insert tab again.
  12. In the Value column, enter the following:
    • 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, replace wp_ with the correct prefix (such as coolPrefix_user_level).
      meta_valueEnter number 10.
  13. Select Go.

You can now sign in to WordPress with your new username and password.

More Info

- SolveForce -

πŸ—‚οΈ Quick Links

Home

Fiber Lookup Tool

Suppliers

Services

Technology

Quote Request

Contact

🌐 Solutions by Sector

Communications & Connectivity

Information Technology (IT)

Industry 4.0 & Automation

Cross-Industry Enabling Technologies

πŸ› οΈ Our Services

Managed IT Services

Cloud Services

Cybersecurity Solutions

Unified Communications (UCaaS)

Internet of Things (IoT)

πŸ” Technology Solutions

Cloud Computing

AI & Machine Learning

Edge Computing

Blockchain

VR/AR Solutions

πŸ’Ό Industries Served

Healthcare

Finance & Insurance

Manufacturing

Education

Retail & Consumer Goods

Energy & Utilities

🌍 Worldwide Coverage

North America

South America

Europe

Asia

Africa

Australia

Oceania

πŸ“š Resources

Blog & Articles

Case Studies

Industry Reports

Whitepapers

FAQs

🀝 Partnerships & Affiliations

Industry Partners

Technology Partners

Affiliations

Awards & Certifications

πŸ“„ Legal & Privacy

Privacy Policy

Terms of Service

Cookie Policy

Accessibility

Site Map


πŸ“ž Contact SolveForce
Toll-Free: 888-765-8301
Email: support@solveforce.com

Follow Us: LinkedIn | Twitter/X | Facebook | YouTube

Newsletter Signup: Subscribe Here