Adding an Admin to Your WordPress Database via MySQL

FeedbackFans.com With the Save: Adding an Admin to Your WordPress Database via MySQL

Locked out of your WordPress admin dashboard? No worries—FeedbackFans.com is here to help! If you need to add an admin user directly to your WordPress database using MySQL, follow these steps to regain access.

Step 1: Access phpMyAdmin

1. Log in to your hosting account and open phpMyAdmin.
2. Select the database associated with your WordPress site from the left-hand menu.

Step 2: Add a New User in the wp_users Table

1. Locate the wp_users table (your table prefix may vary, e.g., wp_ or customprefix_).
2. Click Insert at the top of the table.
3. Fill in the following fields:
   • ID: Enter a unique number not already in use.
   • user_login: Choose a username for the new admin.
   • user_pass: Enter a password and select MD5 in the function column to encrypt it.
   • user_nicename: Add a nickname for the user.
   • user_email: Provide an email address.
   • user_registered: Set the registration date and time.
   • user_status: Set this to 0.
   • display_name: Enter the name you want displayed publicly.
4. Click Go to save.

Step 3: Assign Admin Privileges in the wp_usermeta Table

1. Open the wp_usermeta table in the same database.
2. Click Insert and add the following:
   • user_id: Use the same ID you entered in the wp_users table.
   • meta_key: Enter wp_capabilities (replace wp_ with your table prefix if different).
   • meta_value: Add this value: a:1:{s:13:"administrator";s:1:"1";}.
3. Click Go to save.
4. Insert another row with:
   • user_id: Same as above.
   • meta_key: Enter wp_user_level (adjust prefix if needed).
   • meta_value: Set this to 10.
5. Click Go again.

Step 4: Log In

You can now log in to your WordPress dashboard using the new username and password you created. If the login page isn’t working, you may need to troubleshoot that separately.

Pro Tip

Always back up your database before making changes. If you’re unsure or need assistance, contact your hosting provider or a WordPress expert.

With FeedbackFans.com, you’re never alone in solving website challenges. Stay tuned for more tips and tricks to keep your site running smoothly!