How to Create WordPress Admin User Using phpMyAdmin

According to WIPO (World Intellectual Property Organization), Intellectual Property refers to the creation and labor of the mind, including its fruition. It could be inventions, artistic and literary works, symbols, names, images and designs used in commerce. So, when someone came up with an epic or novel artistic creations, it can be protected in various ways and in many levels. This can be Patents, Trademarks or Copyright. But what are they exactly and how are they any different?

This is one major dilemma of a WordPress designer who inherits a WordPress website without proper documentation and turnover. More often WordPress and Host credentials work but sometimes either or won’t work. In this case it’s the WordPress Admin User that failed to work. But fortunately, you have the hosting credentials working for you.

Managing your WordPress website front-end is being done through the dashboard and not through the host backend. 

Currently, the only way to insert Admin User inside WordPress is through your host and phpMyAdmin. And, if your fellow developer lends a credential before the turnover.


So, in this tutorial we will demonstrate on how to insert WordPress Admin User via phpMyAdmin if all else failed. 

Note: To be safe, always have a backup of your database or better yet your entire website. It won’t take long. Most hosting provider today offer free real-time backup of a website. You can check that out. Also, if you need to save a copy of your entire website (includes database) locally, this plugin will make it a breeze for you – All-In-One WP Migration.

There are several ways of accessing your phpMyAdmin. It all depends on your hosting provider. In my case, I’m using SiteGround. So, check for yourself. In most cases, it’s just a matter of hitting the search feature and typing “phpMyAdmin” and you’ll have it in no time.

The Admin Username we will try to insert will be “TestAdminUser” and a test password is “TestPassword”.

ID: (Input number not in used by other users in the database).
user_login: (Input your username you want to use to login to WordPress dashboard – in my case “TestAdminUser”.
user_pass: (Input your desired password. In my case it’s “TestPassword”.

Note: Important! In the user_pass, click the drop-down menu and select MD5.

user_nicename: (Input the nickname you want to use).
user_email: (Input email address you want to use).
user_url: (This is optional. But you can input your website if you want).
user_registered: (Select/input current date).
user_status: Set to 0.
display_name: (Input the name you want to get displayed on the WP Dashboard).

user_id: Input the ID you have just entered lately, in my case its 3.
meta_key: Input wp_capabilities. In my case, its fuj_capabilities.
meta_value: Input the following:


You should see a yellow-green ribbon above affirming that a new entry was successfully inserted in the table. Otherwise, the ribbon is red if insert is unsuccessful.

user_id: Input the ID you have just entered lately, in my case its 3.
meta_key: Input wp_user_level. In my case, its fuj_user_level.
meta_value: Input number 10.

You should see a yellow-green ribbon above affirming that a new entry was successfully inserted in the table. Otherwise, the ribbon is red if insert is unsuccessful.

Notice that if you click wp_users (or fuj_users), the user we intend to add is already there. Provided you have done it correctly.

In our example, you will notice that we have successfully added our new WordPress Admin User. This user can now function as administrator of the website as intended.

Note: This tutorial has some variability in it. This may work or may not for you depending on your system setup, versions and applications. So check out for yourself. WordPress is dynamically updating the system, this is one thing you need to check as well.





How to Do Super High Resolution Image Search with Google

Gone are the days where you can still deliberately narrow up your image size search with Google. Today, image size searches have been singled-out by Google into just Any Size, Large, Medium and Icon. There will be no way for you to input image size numerically.

Read More

How to Remove or Edit Search Results for in WordPress

Have you ever tried designing a WordPress website and enjoyed its flexibility, only to encounter a hurdle where elements persist stubbornly, even when you don’t need them? Well, this is a classic example of the challenges faced with modular website builders, such as WordPress, and more specifically, the well-known theme builder, Elementor Pro.

Read More


Leave a Reply

Your email address will not be published. Required fields are marked *