How to reset WordPress database

If you are running a test website or you are a developer who messes around with core files in order to create a new plugin or a theme, every now and then you will need a fresh WordPress installation. Of course, you can always install WordPress by overwriting every file there is but that won’t be enough. To make things faster, you will want to reset WordPress database.

Since almost everything in WordPress is stored in databases, to make your installation completely fresh, it is enough to delete those databases. And that’s where WordPress Database Reset comes in handy.

Before you continue, we would like to remind you that there is an easy way of changing database prefix in WordPress without having to reset one.

WordPress Database Reset


How to reset WordPress database

With this free plugin, it is easy and safe to reinitialize databases being used by WordPress. It is very simple and you will have your WordPress reinstalled in a matter of second.

  1. Navigate to Plugins->Add New
  2. Search for “WordPress Database Reset”
  3. Install and activate the plugin

After that you will be automatically redirected to the settings page which contains only the basics which you need in order to delete databases. You are free to choose tables you want to delete which include tables for users, posts, comments, links, options, terms, taxonomies and tables which may have been created by plugins you have previously installed.

After you have selected tables you want to reset you will be given a randomly generated code which is there for security reasons.

  1. Copy the code and paste it into the textbox
  2. Choose if you want to reactivate plugins and themes which you have been using
  3. Click “Reset Databases” if you are sure you want to proceed

It should be noted that if you choose to reset users database, all users except the default admin user will be deleted.

That’s it. Now you have a simple tool which will reset WordPress database in seconds and make your virtual desk a bit cleaner.

Start Blog Book


This guide is an introduction to mastering the art of blogging. It provides easy to follow steps to start, maintain, and grow your blog.

Read the guide

Leave a Reply

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