WordPress: How to manually create a user in the database


Manually creating a WordPress user in the database involves adding a new entry to the wp_users table and assigning the necessary user capabilities. Here are the steps to do this:

Please exercise caution when making direct changes to your WordPress database, as incorrect changes can break your site. Make sure to back up your database before proceeding.

  1. Access Your Database:
    Log in to your server or hosting provider’s control panel and access the phpMyAdmin or a similar tool to manage your WordPress database.
  2. Find the wp_users Table:
    In phpMyAdmin, look for your WordPress database on the left-hand side and click to select it. Then, find and click on the wp_users table.
  3. Insert a New User:
    Click the “Insert” or “Add” tab (the exact label may vary depending on your phpMyAdmin version). This will open a form for adding a new row to the wp_users table.
  4. Fill in User Information:
    Fill in the following fields for the new user:
  • user_login: Enter the desired username for the new user.
  • user_pass: Generate a secure password hash. You can use online tools to create password hashes or use WordPress’s built-in wp_hash_password function. Make sure to select the MD5 option when entering the password hash.
  • user_nicename: This can be the same as the user_login.
  • user_email: Enter the email address for the new user.
  • user_registered: Set the registration date in the format “YYYY-MM-DD HH:MM:SS”.
  • display_name: The display name for the user.
  1. Insert the User:
    Click the “Go” or “Insert” button to insert the new user into the wp_users table.
  2. Assign Capabilities:
    To assign capabilities to the user, you’ll need to find the user’s ID in the wp_users table (it’s typically an auto-incremented number) and then add an entry in the wp_usermeta table.
  • Go to the wp_usermeta table.
  • Insert a new row with the following values:
    • user_id: The ID of the new user from the wp_users table.
    • meta_key: Enter wp_capabilities.
    • meta_value: Insert a serialized array with the user’s capabilities. For example, to make the user an administrator, you can use a:1:{s:13:"administrator";b:1;}.
  1. Login to WordPress:
    You should now be able to log in to your WordPress site using the credentials you provided.

Please be extremely careful when making changes directly to the database, and ensure that you have a backup in case anything goes wrong. It’s recommended to use the WordPress admin interface to create and manage users whenever possible to avoid potential issues.

Discover more from Jorge Saldívar

Subscribe now to keep reading and get access to the full archive.

Continue reading