058 – How to Add an Admin User to the WordPress Database

Listener Feedback

How to add an addon domain

Chad called in with a question about adding an addon domain to his BlueHost hosting account. Listen as I walk him through how to set up his new site.

To Add an Admin User to Database

• In your cPanel, navigate to phpMyAdmin
• Find database for your WordPress site

Edit the wp_user table

• User the “Insert” tab add the following information:

1. user_login – this is the username you want to use to access WordPress
2. user_pass – this is the password you want to use to access WordPress (be sure to select MD5 from the phpMyAdmin Function menu – WordPress stores passwords with MD5 encryption)
3. user_nicename – put whatever you would like to refer to yourself as in here (not your username)
4. user_email – this is the email account associated with this user
5. user_url – the url to your website like – http://www.yourwebsiteengineer.com
6. user_registered – when was this user registered – just select a date with the date selector
7. user_activation_key – you can leave this blank
8. user_status – leave this set to 0
9. display_name – usually I set this to whatever my user_nicename is

– Once you’ve entered the information, hit the “Go” button. This will redirect you so you can see what you’ve entered

Edit the wp_usermeta table

Now that we have added the user we need to give that user the correct privileges.
– User the “Insert” tab add the following information:
1st Record:
1. umeta_id – leave this blank it is automatically generated
2. user_id – this is the id of the user you created in the previous steps
3. meta_key – for this step insert wp_capabilities
4. meta_value – insert exactly this – a:1:{s:13:”administrator”;b:1;}
2nd Record:
1. umeta_id – leave this blank it is automatically generated
2. user_id – this is the id of the user you created in the previous steps
3. meta_key – for this step insert wp_user_level
4. meta_value – insert 10
– Once you’ve entered the information, hit the “Go” button to insert the row.