This guide was updated on

Know how create WordPress users from the database it could come in very handy.

Creating WordPress users from the database plans to work on the site since phpMyAdmin panel. This is a different tool from the WordPress Dashboard (to access it, you will need access to your hosting account).

If you have never made changes to the database and have no programming experience, working with phpMyAdmin may initially be a little complex. In any case, I recommend that you follow the guide to begin to understand how it works.

How to create WordPress users from the database

Well, now that we have made all the necessary premises, we now come to the heart of the matter.

First, to create WordPress users from the database (as described in this tutorial, there are also other methods) it is necessary to work on phpMyAdmin.

Then log into your hosting account and access the cPanel. Inside the cPanel, look for the phpMyAdmin icon and click on it.

At this point, you will be redirected to phpMyAdmin.

Once the page is loaded, select the database for your site from the list on the left. If you have made only one installation of WordPress on your hosting account, you should only have one … finding the right one will therefore be very simple! If you have more than one installation and you don’t know what the database of the site you want to create a new user for is, take a look at the file wp-config.php within the File Manager. Here you will find information on the database that has been ‘connected’ to the folder with the WordPress installation files.

Well, localized the database, click on it to view the tables inside. On the screen that opens, each row corresponds to a table.

Wp_users table

The table that interests us first is the one called, not surprisingly, wp_users. Here are all the information of the users created for the site.

Once the table has been selected, to add a new user simply click Insert at the top right and enter the following information:

    • ID – in this field enter a number of your choice.
    • user_login – the WordPress username you want to assign to the new user.
    • user_pass – the user’s password, selecting the MD5 item from the drop-down menu called ‘functions’.
    • user_nicename – a nickname for the user.


  • user_email – the email address associated with the new user you are creating. Make sure it’s a working email address that you have access to!
  • user_url – a web address to be associated with the user. This can be, for example, the url of a portfolio site or a blog.
  • user_registered – day and time of registration.
  • user_status – this value should be set as 0.
  • display_namand – the name that will appear for the new user on the site.

Well, enter this information you can click ‘Go’ bottom right. We are now halfway through the process of creating WordPress users in the database.

Wp_usermeta table

The second table we have to work on is called wp_usermeta. Here, always clicking Insert, you can add four more fields:

  • unmeta_id – leave this empty space.
  • user_id – in this field enter the same user ID you used in the table wp_users.
  • meta_key – enter here wp_capabilities
  • meta_value – insert a: 1: {s: 13: “administrator”; s: 1: “1”;}


Now, enter yet another row. This time, with the following information:

  • unmeta_id – always leave this field blank.
  • user_id – as we did previously, type the same ID you used in the wp_users table.
  • meta_key – enter here wp_user_level
  • meta_value – finally, type here 10

Well, done all this you can click ‘Go’ bottom right and you’re done! You can now access the dashboard of your WordPress site using the access data that you have configured for the new Administrator user. When you log in, navigate within the profile of the new user you have created and save the configurations again. This will ensure that all configurations are saved correctly for the user.



In this tutorial you learned how to create WordPress users from the database. Overcome the fear of working on phpMyAdmin (and make a nice backup of the whole site!) The steps are quite simple and fast.

Do you have any doubts? Questions? Leave a comment below the post and we will reply as soon as possible.

See you next time.

Leave a reply

Please enter your comment!
Please enter your name here