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.
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.
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!
