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:
a:1:{s:13:"administrator";s:1:"1";}
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.
Enjoy!
According to WIPO (World Intellectual Property Organization), Intellectual Property refers to the creation and labor of the mind, including its fruition.
According to WIPO (World Intellectual Property Organization), Intellectual Property refers to the creation and labor of the mind, including its fruition.
Re-Assigning Nameservers is just a process of redirecting the address to another hosting provider so that files will be solicited from the target hosting site. This happens if your domain registry, such as Web Central or GoDaddy, doesn’t have hosting service available. But mostly, almost all domain registries or hosting providers by now do have all this in one place. Which means, where you registered the domain, there will be a corresponding hosting service at your beck and call.
