WordPress Tutorials

An Ultimate Guide to Reset WordPress

WordPress 1.1Have you ever needed to reset your WordPress password or website to default settings? We believe, if you are running WordPress hosting or using WordPress application on servers, these issues are the problems you need to learn. In the following article, we are going to introduce some methods to solve these problems. Don’t worry! They are easier than you expect.

Reset a WordPress Password

WordPress password is a key factor to protect your website safely. Once your website is hacked by someone or you simple forget your WordPress password, you cannot login your admin panel any more. At that time, to reset your password is to protect your site.

phpmyadmin 2.1One way to reset you password is to use your email that you used to register for your WordPress account. This method is valid to this condition that you just forget your password. However, if your website is hacked, and you cannot use your email to reset your password no longer, you need learn how to reset a WordPress Password from phpMyAdmin. Follow the steps in below to reset your WordPress password.

Firstly, you have to identify the name of your WordPress database. Usually you may run multiple installations in one database, so you’d better know where to reset the password. As we all known, wp-config.php file is the best place located in the root WordPress Directory where you can get the name of you WordPress database.

After knowing your database name, you can locating your database and edit the fields. To be specific, in your control panel or some other admin interface, you need access your MySQL database and browse it through phpMyAdmin. And then, you should choose the right database on your left, according to the name you get in wp-config.php.


Next, you should click it and see a list of tables among which the most part is with a prefix wp_. But if you changed prefix when you installed, you need to look for specific prefix. Find the table ap_users, click that and then click on “Browse” tab. Finally, look for pencil icon to reset the password.


After that, you will find the field changes as following:


Now, you need to edit the value parts. At this moment, you should notice that there is a wide range of random characters in password field. For security, WordPress stores passwords as MD5 hash instead of plain text. So you need use a MD5 generator to obtain your password. Here we recommend JavaScript MD5. Type your password into it, cope the MD5 results from the convert, and then paste it into you phpMyAdmin field.

Finally, click “Go” to finish the process.

Reset Your WordPress Site

To reset your website is very useful when you test new themes or plugins and turn the site into the original setting when you installed at the first time. There are two ways to fix it. The one is to delete the installation and then install WordPress again, which is the last way to consider because it takes effort and time. The other is to hit the reset tab, which is a quite easy way to reset your WordPress website.

Firstly, we would like to introduce an easy to use plugin charging no fees, WordPress Database Reset, which can get in WordPress Directory. It is a tool helping you reset WordPress database to the default settings.

The database in your WordPress will store all your site customizations and information. Due to this, you can reset your WordPress site by resetting your WordPress database back to the original default settings.

After knowing the information, you should start with downloading, installing and activating this plugin. After that, there will be a new item in your menu bar in admin sidebar like this “Tools>Database Reset”. Please note Database Reset is able to delete all the information on your website.


Click the new item in menu bar and then choose the tables that you are going to reset. Besides, you have “Select All” item to reset your website completely just by clicking it.


If you just select some individual table, the plugin will just delete the specific content you choose, like all your pages, all comments, and all users on the website. Of course, your admin is not included.

If you really select all, this Database Reset will show you a checkbox to ask whether you need to reactivate the current plugins and theme on your website after resetting. If you want, check the box; if you don’t want, you just leave the box unchecked.

And then, in the text field you need to type the security code; next you should click “Reset”. After doing this, you are turned back to your WordPress dashboard, and all settings of your WordPress website will be back to the defaults.

In the end, the Database Reset will pop out a prompt to confirm whether you like to continue the process. Just click “OK”, you are done for resetting your WordPress site back to the original defaults.


The Second Way to Use Database Reset Plugin

Apart from the method above, we are glad to introduce an easier way than using this Database Reset only. It is useful to advanced users like theme and plugin developers. It is to use the Database Reset with your WordPress command line.

If you installed and activated WordPress command line interface, you are able to reset your database by doing with the command “wp reset database”. Or you are able to list the specific tables which you want to reset, such as “wp reset database –tables=’links, posts, users, options‘”.

Lastly, we have to emphasize again that the Database Reset will delete all the customization and information on your site when you choose all tables. Please be careful to use it when you indeed want to fully remove all the current content on your site.

To sum up, if you need to reset your WordPress site frequently and really hate to experience the WordPress 5-minute installation process every time, we highly recommend you to install this easy to use this Database Reset plugin.

For more WordPress tutorials or related reviews, please go to our BigCheaphosting.com blog.

Leave a Reply

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