Creating a new WordPress site user login details via your phpMyadmin site database could probably save you from some technical headaches most especially when you forget your password or you are been locked out of your site due to some attacks from hackers. You might think this article is useless because you gonna feel like you have another option to recover your login details via resetting your details with the “Forgot Password” option. So what if your email was been altered after the attacker got into your site or your email service isn’t active?, then you are left with nothing but with this guide, you can simply act fast in order to gain full access back to your site.
Yeah, we both know this ain’t my first article on WordPress. Recently I wrote a complete A-Z guide on How to install a self hosted WordPress Site Via cPanel. I have been offline for some days now and during my off, I came across one of my Facebook pals who told me he couldn’t access his WordPress Dashboard and I was not happy hearing that upon all he has tried, this eventually led me to write an article on How To Create New WordPress Site User Login Details Via phpMyAdmin.
Firstly, I need to draw your attention to the fact that you can only practice this tutorial on a self hosted WordPress site which you personally host or have access to its cPanel.
What is phpMyAdmin?
According to WordPress Codex, its an administrator’s tool of sorts, phpMyAdmin is really a PHP script intended for giving its end users the opportunity to communicate with their MySQL databases. WordPress stores all its information within the MySQL database and communicates using the database to create information in your WordPress site. A “raw” look at the information, tables and fields kept in the MySQL database is obtainable through phpMyAdmin. The phpMyAdmin program is handy for carrying out maintenance procedures on tables, data backups, and editing things directly when WordPress isn’t working.
What Can You Do Within The phpMyadmin Database?
Through this software you can create, alter, drop, delete, import and export MySQL database tables and as well can run MySQL queries, optimize, repair and check tables, change collation and execute other database management commands.
OK, let me quickly work you through the case study of this guide and I believe we both have great ideas of what we are about to set on 🙂 .
How To Create New WordPress Site User Login Details Via phpMyAdmin
Before we go ahead, you need to login to your web hosting cPanel. NOTE: Be careful.
⇒ Now locate and open “phpMyAdmin”
⇒ Now that you are in the “phpMyAdmin” Database window
⇒ Click on the affected WordPress site database name that you wanna alter or add New WordPress Site User Login Details.
⇒ Now locate and click on the table with “_users”
NOTE: WordPress user password can use MD5 Passwords and am just gonna show you a site where you can simply generate one to replace the old password you forgot.
The site I use is http://md5cracker.org/create-md5 and we just gonna generate a new hash password to gain access to our WordPress site.
Lets say we are generating hash password of 123456789 which is 25f9e794323b453885f5181f1b624d0b
Now double click the “user_pass” box in the tables and replace the former hash with your newly generated hash. if you wanna use 123456789 as your new password, then you simply gonna use the above hash to replace the old one.
Once you done replacing with new password, then press enter.
If you also wanna change your admin mail, simply double click “user_mail” and edit, then press enter to accept inputs. Same applies to username.
⇒ Now that we are done making changes to the database tables, you can simply login to your WordPress Site Dashboard with your new password.
Conclusion: There you go logging into your site with full admin roll and access. Please once you are in your Dashboard, Simply navigate through “Users” and change your password to your newly desired one. Don’t leave the hash password your generated as your new on because most password hash sites stores passwords been generated via them and can later be used against your site anytime.
With great power comes great responsibility. phpMyAdmin enables you to definitely communicate with the database directly: additionally, it allows you screw up the database directly. There’s no “undo” or “undelete” inside your database. Always exercise caution whenever using the database.
Do you have any question or query? then remember to share via comment box below. also remember to help your friends by sharing this article in order to ease their pain and at the same time saving them from loosing hope on thier sites. 🙂
Click Here To Read All My WordPress Related Articles.