Featured templates

WordPress. How to change database tables prefix via admin panel

Jason Bentley February 17, 2017
Rating: 5.0. From 1 vote.
Please wait...

Our Support team is ready to present you a new tutorial that shows how to manage database tables prefix via admin panel.

WordPress Database is like a brain for your entire WordPress site because every single information is stored in there thus making it hacker’s favorite target. Spammers and hackers run automated codes for SQL injections.

Well, unfortunately many people forget to change the database prefix while they install WordPress. This makes it easier for hackers to plan a mass attack by targeting the default prefix wp_.

The smartest way you can protect your database is by changing the database prefix which is really easy to do on a site that you are setting up. But it takes a few steps to change the WordPress database prefix properly for your established site without completely messing it up.

We recommend that you backup your WordPress Database before you perform anything suggested in this tutorial.

You will be able to change database tables prefix via WordPress admin panel.

  1. Navigate to Plugins -> Add new section.

  2. Type in search change-table-prefix , you will see a list of recommended plugins .

  3. Click on Install Now & Activate Change Table Prefix plugin .

  4. After that, navigate to Settings -> Change table prefix.

  5. Select the following option, Would you like to use your own custom prefix and type a prefix you want to use in field, for example wpnew_ .

  6. You will get a message about successful prefix replacement.



This plugin is mainly useful if you have not changed the database prefix at the time of installation and want to change afterwards to make your website more secure and protect from SQL injections. With the use of this plugin, you can easily replace your database default prefix to other prefix by a single click.

As in most of the cases adminer are not changing the WordPress default database table prefix, it is easy for any hackers to inject to your database as all the default tables name are know for all. But if you modify your database tables prefix then your tables name become unknown to outside world. Now the question is how to change table prefix.


  • Can change database tables prefix in post installation.

  • Tables prefix will change by single click.

  • Works well for multi site present in a single database.

  • Both the custom and random generated prefix facility available.

  • Minimize the SQL injection.

Thank you for reading this tutorial. Now you know how to change database tables prefix via WordPress admin panel.

Do you want the best WordPress template of this year? Look through our selection of the best WordPress themes in 2017.

Feel free to check the detailed video tutorial below:

WordPress. How to change database tables prefix via admin panel
Cool Wordpress Themes
This entry was posted in WordPress Tutorials and tagged database, prefix, WordPress. Bookmark the permalink.

Submit a ticket

If you are still unable to find a sufficient tutorial regarding your issue please use the following link to submit a request to our technical support team. We'll provide you with our help and assistance within next 24 hours: Submit a ticket