softmaji-header-wbg-min
softmaji-header-wbg-min
softmaji-blue-header-min
softmaji-blue-header-min
  • Home
  • Services
    • Website Designing
      • Responsive Website Design
      • Static Website Design
      • Website Redesign
      • Landing Page Design
    • Website Development
      • PHP Website Development
      • WordPress Website Development
      • Ecommerce Website Development
      • Custom Website Development
    • Digital Marketing
      • Google Adwords/PPC
      • Facebook Promotion
    • SEO Service
  • Trainings
    • Learn Web Development
    • Learn Graphics Design
    • Learn Business Communication Skills
  • Pricing
  • Portfolio
  • Events
  • Offers
  • Contact Us

How to Add an Admin User to the WordPress Database from phpMyAdmin?

HomeHow to Add an Admin User to the WordPress Database from phpMyAdmin?

Offer Expire Soon..


Only New User..


Steps to add an Admin user to the WordPress database from phpMyAdmin:

  • Log in to cPanel.
  • Navigate to the Databases section and click on phpMyAdmin.
  • Choose your database. It might be possible that you have multiple databases in your phpMyadmin.

So to find the appropriate database name just follow these steps:

  • On the cPanel dashboard, click on File Manager.
  • Go to the public_html folder and click on wp.
  • On the right side, you will get files and folders in that, right-click on the wp-config.php file and click on the view option.
  • In this section, you will see the database name.
  • Now, go back to phpMyAdmin and click on the databasename_users table. In our case, the database table name is this.
  • Click on Insert.
  • Fill the required information in the mentioned fields.
  • In the user_pass dropdown, select MD5.
  • Click on Go.
  • Click on the databasename_users table.
  • As you can see the recently added record with ID. In the next step, we will use this id in the user_id field.
  • Select the databasename_usermeta table and click on Insert.
  • Enter the id of the user which we have created in the previous query.
  • In the meta_key textbox, enter the databasename_capabilities. In our case, meta_key is this.
  • In the meta_value textbox add this code: a:1:{s:13:”administrator”;s:1:”1″;}
  • Again in this section, enter the user_id.
  • In the meta_key textbox, enter the databasename_user_level. In our case, meta_key is this.
  • In the meta_value textbox, enter the value as 10.
  • Click on Go.

Now, follow the steps to check the newly added admin user in WordPress:

  • Log in to WordPress with a newly created username and password.
  • Click on Users.
  • As you can see the newly created username with Administrator role.

That’s how you can add an admin user to the WordPress Database from phpMyAdmin.

Faizan Khan
26
Content Management System (CMS), Latest News, WordPress
Prev PostHow to Edit the Profile in WordPress?May 11, 2024
Next PostHow to Install WordPress Locally on Windows?May 11, 2024

Related items

Latest News

How To Install WordPress Blog?

Let’s see how to install WordPress blog on your WordPress hosting account. Let’s

Faizan Khan
14/05/2024
147
Latest News

How to Install a Theme in WordPress?

Steps to install a theme in WordPress: Log in to WordPress. Navigate to Appearance and cli

Faizan Khan
14/05/2024
131
Latest News

Fatal error: Allowed memory size of xxxx bytes exhausted (tried to allocate xx bytes)

WordPress is a free open source blogging tool. When posting a article OR uploading a image

Faizan Khan
14/05/2024
144
softmaji-header-wbg-min
SoftMaji is one of the affordable web development company in the web development industry. You don’t have to go searching anywhere for finding a reliable web development partner because we have crafted web development solutions that can fill the void left by others in the market.
Services
  • News Portal Development
  • Custom Website Development
  • PHP Website Development
  • Ecommerce Website Development
  • WordPress Website Development
Shortlinks
  • Blog
  • Offers
  • Events
  • Pricing
  • Reviews
  • Portfolio
  • Our Team
  • Payment Options
  • Explore Packages
Company
  • FAQ
  • Careers
  • Sitemap
  • Feedback
  • About Us
  • Contact Us
  • Privacy Policy
  • Terms & Conditions
  • Refund And Cancellation
Contact Us
4/40 Vipul Khand , Gomti Nagar Lucknow
Uttar Pradesh 226010
Landline - +915223162418
Email - hello@softmaji.in
Office Time Mon - Sat
(10:00AM - 5:00PM)
Sunday Close
+91 9795405324
Lucknow , Uttar Pradesh
Copyright © 2022. All Rights Reserved.