{"id":1434,"date":"2022-03-03T11:35:53","date_gmt":"2022-03-03T06:05:53","guid":{"rendered":"https:\/\/hostkicker.com\/blog\/?p=1434"},"modified":"2022-03-08T17:28:22","modified_gmt":"2022-03-08T11:58:22","slug":"how-to-add-an-admin-user-to-the-wordpress-database-via-mysql","status":"publish","type":"post","link":"https:\/\/hostkicker.com\/blog\/how-to-add-an-admin-user-to-the-wordpress-database-via-mysql\/","title":{"rendered":"How to Add an Admin User to the WordPress Database via MySQL"},"content":{"rendered":"

Are you searching for a way to add an Admin User to the WordPress Database via MySQL? <\/span>This post will share, How to Add an Admin User to the WordPress Database via MySQL.<\/span><\/p>\n

If you can not access your wp-admin area for reasons such as your site being hacked, you forgot your password, your site displaying some error, or are locked out of your site. Don’t worry! There’s another way to gain access to your site.<\/span><\/p>\n

You can make a new WordPress admin user by editing your site’s database.<\/span><\/p>\n

Creating a new WordPress admin user with phpMyAdmin<\/span><\/h2>\n

You can make a new WordPress admin user by following the steps below:\u00a0<\/span><\/p>\n

    \n
  1. Access your MySQL database<\/span><\/li>\n
  2. visit the\u00a0<\/span>wp_users<\/span><\/em>\u00a0table<\/span><\/li>\n
  3. Insert a new WordPress admin user in the user’s table<\/span><\/li>\n
  4. Insert user meta values<\/span><\/li>\n<\/ol>\n

    Note:\u00a0\u00a0<\/span><\/strong>Before doing anything, You must create a backup of your database.\u00a0<\/span><\/p>\n

    Let’s get started!<\/span><\/p>\n

    Step 1: Access your MySQL database<\/span><\/h3>\n

    To start, you have to access your hosting c-panel and then locate your WordPress database section to edit it. Then click on the phpMyAdmin option provided there.<\/span><\/p>\n

    \"\"<\/p>\n

    Step 2: Visit the\u00a0<\/span>wp_users<\/span><\/em>\u00a0table.<\/span><\/h3>\n

    After that, search for the\u00a0\u00a0<\/span>wp_users<\/span><\/strong>\u00a0and click it. We have to edit the wp_users and wp_usermeta tables.<\/span><\/p>\n

    \"\"<\/p>\n

    Step 3: Insert a new WordPress admin user<\/span><\/h3>\n

    Now, click<\/span>\u00a0the insert<\/span><\/strong>\u00a0option in the\u00a0<\/span>wp_users<\/span><\/strong>\u00a0table to insert our new admin user’s information.<\/span><\/p>\n

    \"\"<\/p>\n

    Next, you will see the insert form. you have to add the following details:<\/span><\/p>\n