WordPress Coding
How To Learn Create Admin Role Through MySQL Query In WordPress

How To Learn Create Admin Role Through MySQL Query In WordPress

By: SolutionsHint    129 views Updated: 07th Apr, 2018
Create Admin Role Through MySQL Query In WordPress

in This tutorial, I will explain how to create admin role in WordPress through phpmyadmin , because sometimes we forget or truncated users table and lost our admin credential the, could not login into WordPress dashboard, in this case, we look for the way that helps me to create the admin role through MySQL. So I have the easiest way that will really help to create admin role in quick step by using these query.

Follow these steps to create admin Role.

How to Create Admin Role Through MySQL

  1. Fist login into PHPMyAdmin
  2. Select your database to whom you want to create admin role
  3. After selecting a database, click on SQL tab from the top of PHPMyAdmin pannel
  4. Now run the below query to create the admin role

Step 1: the First query will create the user for WordPress

Step 2:  Now will create the admin role and its capability in the usermeta table of WordPress.

Step 3: Now will set the user level for admin

Notes: 10 for admin, Anything else pleases leave a comment.

 

 

About the Author

I am a professional blogger from my heart, I am going through all the possible ways that can help to audience. I am trying my best to write content that my readers will like me. I will really be happy when my readers will become more happy with my blog.

Leave a Reply

Your email address will not be published. Required fields are marked *