WordPress is one of the greatest Blogging web application and many websites are using it as their CMS. If you are forgotten your login credentials for your wordpress then you don’t need to uninstall your wordpress from your website are you don’t need to take any backup.
In this post I’m going to tell you about how you can change your wordpress login credential if you don’t use your email at the time of wordpress installation by using only hosting login credential for changing your wordpress username and password. So lets get started with the screenshots.
First of all you need to login your hosting account where you buy your website hosting. You can find your login credential from your email that you was used at the time of purchasing Hosting. So note these login credential and open your hosting control panel.
Now go on database section and select the database that you used for your wordpress website. If you don’t know what is your database then open your ftp client of online file manager on your hosting control panel and open the wordpress installation directory. Now open the file wp-config.php and then find ‘DB_NAME’ after this term you can get your database name.
Now open phpMyAdmin and then click on your database name and then select ‘wp_users’ here wp is your database prefix that you was used at the time of wordpress installation so please keep in mind your database prefix. You can also find wordpress prefix in wp-config.php file.
After clicking on wp_users you can find your all the users list with the username and password now select a row from this table and click on edit. Now you can change your wordpress username and password. But if you want to change your password you need to select MD5 from the options drop down menu and then type your password.
OTHER WAY TO CHANGE YOUR WORDPRESS USER NAME AND PASSWORD:
If you want to change your username and password by using sql query then you can use the following command for changing your wordpress username and password.
Thanks for reading my post and get connected with our blog for getting more stuff like this.
Arvind Singh is a Web Developer / Blogger and Also a Youtuber. He Explores what’s possible with WordPress, Blogger, Mobile Phones, Web Development and shares his Knowledge with the Readers.