• Home
  • Computer Tips & Tricks
  • Game Tricks And Fixes
  • Internet Tricks
  • WordPress Tutorials
  • More Topics
    • Windows Tutorials
    • Andriod Tutorials
    • Adobe Premiere Pro Tutorials
    • Youtube Tips And Tricks

Subscribe to Updates

Get the latest creative news from FooBar about art, design and business.

What's Hot

How to Create WordPress Admin User in phpMyAdmin?

May 18, 2023

How to Fix “Rankmath Causes Critical Error: Instant Index Status Error undefined – There has been a critical error on this website.”Quickly?

May 18, 2023

How to Fix “Sorry, You are not allowed to access this page” Error in WordPress?

May 16, 2023
What's Hot

How to Create WordPress Admin User in phpMyAdmin?

May 18, 2023

How to Fix “Rankmath Causes Critical Error: Instant Index Status Error undefined – There has been a critical error on this website.”Quickly?

May 18, 2023

How to Fix “Sorry, You are not allowed to access this page” Error in WordPress?

May 16, 2023
Lets Make It EasyLets Make It Easy
  • Home
  • Computer Tips & Tricks

    How to Fix “Error 195- AMD Software Installer Cannot Continue Because It Is Unable to Access the Required Web Resources” Problem Quickly?

    May 7, 2023

    How to Fix “Taskbar is Not Working / Not Showing Up in Windows 7,8,10,11?

    May 4, 2023

    How to Fix “Word Cannot Complete the Save Due to a File Permission Error” Easily?

    April 30, 2023

    How to Fix “Failed to Enumerate Objects in the Container. Access is denied” Error?

    April 22, 2023

    How to Permanently Remove/Disable/Uninstall the Feedback Hub in Windows 10,11?

    April 22, 2023
  • Game Tricks And Fixes

    How to Fix Failed to initialize Direct3D error on Windows 7,8,8.1,10 & 11?

    March 31, 2023

    How to Download & Clean Install Nvidia Drivers on Windows 10 & 11?

    February 15, 2023

    How to Download & Install Nvidia Drivers (Older Versions) on Windows 10 & 11?

    February 15, 2023

    How to Fix GTA IV (GTA 4) SecuLauncher error 2000 in Windows 7,8,10 &11?

    February 14, 2023

    How to Fix “SecuLauncher Failed to Start Application 2000 in GTA 4” Error in Windows 7,8,10 &11?

    February 14, 2023
  • Internet Tricks

    How to Fix JIO FIBER’s Red Light Blinking Problem Easily?

    April 26, 2023

    How to Repair a Corrupted MySQL Database Table?

    March 2, 2023

    How to Convert EPUB to PDF for Free Online & Offline?

    February 28, 2023

    How to Get Quick Adsense Approval for WordPress Blog/Website?

    February 27, 2023

    How to Remove/Delete Your Site from Ezoic Network?

    February 5, 2023
  • WordPress Tutorials

    How to Create WordPress Admin User in phpMyAdmin?

    May 18, 2023

    How to Fix “Rankmath Causes Critical Error: Instant Index Status Error undefined – There has been a critical error on this website.”Quickly?

    May 18, 2023

    How to Fix “Sorry, You are not allowed to access this page” Error in WordPress?

    May 16, 2023

    How to Add an Admin User in WordPress using FTP or cPanel File Manager?

    May 10, 2023

    How to Fix “Update failed / Download failed. Could not open handle for fopen()” in WordPress?

    May 10, 2023
  • More Topics
    • Windows Tutorials
    • Andriod Tutorials
    • Adobe Premiere Pro Tutorials
    • Youtube Tips And Tricks
Lets Make It EasyLets Make It Easy
Home » How to Create WordPress Admin User in phpMyAdmin?
Wordpress Tutorials

How to Create WordPress Admin User in phpMyAdmin?

AuthorBy AuthorMay 18, 2023
How to Create Wordpress Admin User in phpMyAdmin?

Hi Guys, Today I am Going to Show You How to Create WordPress Admin User in phpMyAdmin?

If You’re Looking for the Commonly Searched WordPress Error “How to Create WordPress Admin User in phpMyAdmin?” (or) ” How to Add an Admin User to the WordPress Database via MySQL.?”.You are at the Right Place to Get Your Answers & Solve the Issue/Error. 

One of the Most Frustrating issues in WordPress is when you’re the actual Admin of your Website and you’re not able to log in to your Account. Your Website will show an error “Sorry, you are not allowed to access this page”. This Issue Happens due to many reasons such as a forgotten username and password, the active user account may get deleted, the Admin rights of the user getting removed, A User Account being deleted by security plugins (or) your site may have been hacked. This Issue needs to be fixed immediately to avoid further problems.

Trending
How to Hide/Remove Theme Name in WordPress?

The Easiest Way to Fix this Issue is to add a Temporary Admin User through FTP. This Temporary Admin User is used to log in to your account temporarily. After Logging in to your Account with this new temporary admin account, You need to Change the Admin Rights to the Original User Account. And then Log in to your WordPress admin panel with that Original Account. You must remove admin rights from the temporary admin account and delete the temporary admin account. And also remove the code also. If you’re new to WordPress, don’t worry follow our steps carefully. We provided a Step by Step Tutorial for Adding Admin User in WordPress through FTP or File Manager.

Trending Now : How to Fix “Error 195- AMD Software Installer Cannot Continue Because It Is Unable to Access the Required Web Resources” Problem Quickly?

Step 1: First of all, Goto your Website Hosting Site. Log into your Account & Open the C-Panel.

 Step 2: On Your C-Panel, Navigate to the Database Section and Click on the phpMyAdmin to Open the phpMyAdmin Interface.

 Step 3: You need to click on your WordPress site’s database from the databases list that is available on your Left Side Pane.

 Step 4: Now All tables under which comes your WordPress Database will be displayed, Look for the wp_users and Click on it.

 Step 5: After Clicking on the wp_ Users table, Click on the Insert Option to Add the New Admin User.

 Step 6: Now You Need to Enter the Following Details in the Required Fields to Create the User Successfully.

Things to Know Before Filling the Required Fields

1. On the ID Field: You can a Number as per your users list. We use 3 because we have already 2 users.

2. On the user_login Field: You Need to Enter the username that you want to use for logging in.

3. On the user_pass Field: You need to enter the password & select MD5 Option in the function settings.

4. On the user_nicename Field: You can either Enter your user name or nickname.

5. On the user_email Field: You need to enter the email address for the new user.

6. On the user_url Field: You need to enter the website address correctly.

7. On the user_registered Field: You Need to Set the Date & Time on the calendar.

8. On the user_activation_key Field: No need to enter anything just leave this field empty.

9. On the user_status Field: You can simply set the value to 0.

10. On the display_name Field: You need to Enter the full name of the user or a display name for the user.

 Step 7:  After filling in all the information Successfully, Scroll Down and Press Go Button.

 Step 8: Now Again Click on your WordPress site’s database from the databases list & Look for the wp_usermeta and Click on it.

 Step 9: Now You Need to Enter the Following Details in the Required Fields. 

Things to Know Before Filling the Required Fields

1.On the user_id Field: You need to enter the ID of the user you created in the wp_users table.

2. On the meta_key Field: You can simply Enter wp_capabilities in this field.

3. On meta_value Field: You need to enter the following value in the field.

a:1:{s:13:”administrator”;s:1:”1″;}

Step 10: Now You can See the Second Row, So You Need to Enter the Following Details in the Required Fields to finish the process Successfully.

Things to Know Before Filling the Required Fields

1. On the unmeta_id Field: Just leave this field empty it will be auto-generated.

2. On the user_id Field:  You need to enter the ID of the user you created in the wp_users table.

3. On the meta_key Field: You Should Enter wp_user_level in this field.

4. On the meta_value Field: You need to enter 10 as the value in this field.

Step 11:  Now you need to Click on the Go Button to complete the Admin User Creation Process.

 Step 12: Now Login to your WordPress Admin Account With the New Username, and Password.

Step 13:  After Logging into your account, Navigate to Users and You need to delete the User that you’ve created.

That’s All About this Post. Give Your Reviews / Reactions about this Post and Leave Comments, Ask Your Doubts, We are here to Help You!

Add a New WordPress Admin User via MySQL Add Admin User to the Database using PHP add admin user to wordpress site add admin user wordpress add admin user wordpress functions php create a new WordPress admin user with phpMyAdmin how to create admin user in phpmyadmin how to create wordpress admin user in phpmyadmin Sorry you are not allowed to access this page. you are not allowed to access this page
Previous ArticleHow to Fix “Rankmath Causes Critical Error: Instant Index Status Error undefined – There has been a critical error on this website.”Quickly?
Author

Basically an Instrumentation Engineer But Very much Interested in Blogging. I'm a Passionate Blogger and an Expert in Search Engine Optimization And Always Looking Forward to Learn New Things. I Would Fix & Provide Solution to the Most Common Issues Related to PC,Laptops,Mobiles,OS, Hardwares and Softwares.

Related Posts

Wordpress Tutorials

How to Fix “Rankmath Causes Critical Error: Instant Index Status Error undefined – There has been a critical error on this website.”Quickly?

May 18, 2023
Wordpress Tutorials

How to Fix “Sorry, You are not allowed to access this page” Error in WordPress?

May 16, 2023
Wordpress Tutorials

How to Add an Admin User in WordPress using FTP or cPanel File Manager?

May 10, 2023
Add A Comment

Leave A Reply Cancel Reply

Subscribe to Updates

Get the latest tech news from FooBar about tech, design and biz.

Most Popular
  • Trending:How to Fix “Sorry, You are not allowed to access this page” Error in WordPress?
    by Author|May 16, 2023
    0
  • Trending:How to Add an Admin User in WordPress using FTP or cPanel File Manager?
    by Author|May 10, 2023
    0
  • Trending:How to Fix “Update failed / Download failed. Could not open handle for fopen()” in WordPress?
    by Author|May 10, 2023
    0
  • Trending:How to Fix “Error 195- AMD Software Installer Cannot Continue Because It Is Unable to Access the Required Web Resources” Problem Quickly?
    by Author|May 7, 2023
    0
  • Trending:How to Fix “Taskbar is Not Working / Not Showing Up in Windows 7,8,10,11?
    by Author|May 4, 2023
    0

Top Posts

How to Fix “Error 195- AMD Software Installer Cannot Continue Because It Is Unable to Access the Required Web Resources” Problem Quickly?

May 7, 2023118 Views

How to Fix “Oops looks like the page is lost. This is not a fault just an accident that was not intentional.”Error?

April 26, 202380 Views

How to Configure Jio Fiber Router? | Reliance Jio Fiber Router JCO4032 Settings [ Updated ]

December 9, 202241 Views
Editor's Pick
Internet Tricks

How to Configure Jio Fiber Router? | Reliance Jio Fiber Router JCO4032 Settings [ Updated ]

AuthorDecember 9, 2022
Adobe Premiere Pro Tutorials

How to Fix “A low-level exception occurred in ImporterMPEG” Error in Adobe Premiere Pro?

AuthorDecember 9, 2022
Adobe Premiere Pro Tutorials

How to Fix Loading ImporterQuicktime.prm in Adobe Premiere Pro?

AuthorDecember 9, 2022
Internet Tricks

How to Fix JIO FIBER’s Red Light Blinking Problem Easily?

AuthorApril 26, 2023
Latest Articles

The Ultimate Technology Site About Technical Support, Information Technology, PC Builds, Domain Hosting, WordPress, Blogger.Letsmakeiteasy is a site where you can learn about technology, Search Engine Optimisation, Computer and Mobile Tricks, Blogging and WordPress Tips. We are Here to Help You.

Most Popular

How to Fix “Error 195- AMD Software Installer Cannot Continue Because It Is Unable to Access the Required Web Resources” Problem Quickly?

May 7, 2023118 Views

How to Fix “Oops looks like the page is lost. This is not a fault just an accident that was not intentional.”Error?

April 26, 202380 Views

How to Configure Jio Fiber Router? | Reliance Jio Fiber Router JCO4032 Settings [ Updated ]

December 9, 202241 Views
Our Picks

How to Create WordPress Admin User in phpMyAdmin?

May 18, 2023

How to Fix “Rankmath Causes Critical Error: Instant Index Status Error undefined – There has been a critical error on this website.”Quickly?

May 18, 2023

How to Fix “Sorry, You are not allowed to access this page” Error in WordPress?

May 16, 2023
  • Home
  • About Us
  • Contact Us
  • Sitemap
Copyright © 2023 Letsmakeiteasy.tech LLC. All Rights Reserved. | Crafted With ❤️ | Created by Vasantharaj R N

Type above and press Enter to search. Press Esc to cancel.