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.
- 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.
- Find the
In phpMyAdmin, look for your WordPress database on the left-hand side and click to select it. Then, find and click on the
- 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
- 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_passwordfunction. Make sure to select the MD5 option when entering the password hash.
user_nicename: This can be the same as the
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.
- Insert the User:
Click the “Go” or “Insert” button to insert the new user into the
- Assign Capabilities:
To assign capabilities to the user, you’ll need to find the user’s ID in the
wp_userstable (it’s typically an auto-incremented number) and then add an entry in the
- Go to the
- Insert a new row with the following values:
user_id: The ID of the new user from the
meta_value: Insert a serialized array with the user’s capabilities. For example, to make the user an administrator, you can use
- 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.