How to Add a WordPress User From phpmyadmin





The interactive transcript could not be loaded.



Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on Dec 22, 2012

If you ever do need to add a user to WordPress manually, that is through phpMyAdmin, this is how you would do it...

If you like this video please subscribe to my new Channel http://www.youtube.com/user/bescientifik

So, Why not make a user inside the WordPress administration? Because you've probably messed something up.
"You do not have sufficient permissions to access this page" sound familiar?
I go over SOME reasons you might need (I needed) to use the phpmyadmin method is at 4:23 of the video.

Right now I'm using zorkboy.com, just installed WordPress on it.

1: 0:55 Log into phpMyAdmin within your server dashboard, I use http://www.site5.com/in.php?id=109829 hosting.

2: 1:05 Locate and select your Wordpress database.
If you do not know your username, password, or even the name of your database you can find it in your wp-config.php file.

Back in phpmyadmin you will now see a list of your database tables.
You will need to change the wp_users and the wp_usermeta table.

3: Click on the wp_users table to bring up the data for that table. You should see a list of the current users come up -- or if you do not have any users you would see the list of database fields available to fill in for a new user.

4: 1:46 Click on the Insert tab.
We will need to insert a row into the database with our new user information.

user_login -- this is the username you want to use to access Wordpress
user_pass -- this is the password you want to use to access Wordpress (Wordpress stores passwords with MD5 encryption)
user_nicename -- put whatever you would like to refer to yourself as in here (not your username)
user_email -- this is the email account associated with this user
user_url -- the url to your website like -- http://www.webenvelopment.com
user_registered -- Pick a date with the date selector
user_activation_key -- Leave this blank. WordPress uses it on it's own
user_status -- leave this set to "0"
display_name -- The new user's display name sitewide

Hit "Go" to create this user. You should see Green like I had in the video. 3:23
If not double check all this information.

5: 3:39 Hit wp_users again to see you new user! (take note of the new user's id)

Now lets give that new user some permissions.

6: 3:48 Click on the wp_usermeta table

7: 3:55 Click on the "Insert" tab

Fill in the following information
umeta_id - leave this blank it is automatically generated
user_id -- this is the id of the user you created in the previous steps
meta_key -- for this step insert wp_capabilities
meta_value -- insert exactly this -- a:1:{s:13:"administrator";b:1;­}

Insert another row with this information

umeta_id - leave this blank it is automatically generated
user_id -- this is the id of the user you created in the previous steps
meta_key -- for this step insert wp_user_level
meta_value -- insert 10
Click the "Go" button in phpMyAdmin to insert the row.

The user you created should be live and have the ability to login to your WordPress administration at your.com/wp-admin


When autoplay is enabled, a suggested video will automatically play next.

Up next

to add this to Watch Later

Add to

Loading playlists...