This plugin hasn’t been tested with the latest three major releases of WordPress. It may no longer be maintained or supported and may have compatibility issues when used with more recent versions of WordPress.

Change Table Prefix

Description

Latest version compatible with WordPress multisite installation here

This plugin is mainly useful if you have not changed the database prefix at the time of installation and want to change post installation to make your website more secure and protected from SQL injections. With the use of this plug-in you can easily replace your database default prefix to any other prefix in 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 names are know for all. But if you modify your database tables prefix then your tables names are become unknown to outside world.

Plug-in URL: Change Table Prefix

Features

  • 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.

Installation

  • Upload change-table-prefix to the /wp-content/plugins/ directory.
  • Activate the plug-in through the ‘Plugins’ menu in WordPress.
  • Configure the new prefix in Settings -> Change Table Prefix.

Reviews

16 January 2020
It was scary, but I made a full backup and tried this Plugin. I used it on WordPress 5.3.2 and it works fine. It will change all tables prefix and still you're in Admin area, you're not logged out or something. Then, you just need to go and change the prefix line in wp-config.php using hosting file manager or via FTP and that's all. PLUGIN WORKS PERFECT. WEBSITE WORKS PERFECT. I checked out phpMyAdmin to see changes, and all tables for the website are named with the new prefix. Nice. I wish hope developer continue this great job. Thanks for this great plugin !!!
25 November 2019
Despite being a bit out of date and a number of releases behind (at the time of this review), this software worked reliably with a complex update that included non-WP base tables. It will be a pity if the owner has stopped supporting this plugin.
25 September 2019
I have juste change the "wp-config.php". Weldone !
10 July 2019
I just successfully changed the prefix of a WP 5.2.2 Multisite installation. Immediately after the plugin changed the prefix, the site was broken, but all I had to do was update $table_prefix in wp-config.php and then everything was fine. It also worked in regular WP 5.2.2 without the need to edit wp-config.php
26 May 2019
I just tried this plugin and it worked perfectly. I saw that all of the 1-star reviews were from 2+ years ago. I was concerned. But, I'm suspecting that the plugin was corrected since it worked fine in my situation and, that there haven't been any other 1 star reviews for years. Note: As of 5/25/2019 I am running the most current version of this plugin as well as the most current version of WordPress. So from what I am seeing, it should be considered good and I wouldn't expect the problems that were reported 2+ years ago. Thumbs up to the developer of this plugin. Thanks, Gary Gordon wpbns.com
Read all 48 reviews

Contributors & Developers

“Change Table Prefix” is open source software. The following people have contributed to this plugin.

Contributors

Translate “Change Table Prefix” into your language.

Interested in development?

Browse the code, check out the SVN repository, or subscribe to the development log by RSS.

Change log

2.0

  • Tested with upto WP 5.0.x
  • Take any combination of letters, numbers and (_) with first character always alphanumeric.
  • Check first character is always alphanumeric or not.
  • Blank submission of custom table prefix will change prefix with randomly generated 5 characters and a message appears that custom table prefix can not be empty.

1.4

  • Tested with upto WP 4.5.2
  • Disable direct access.
  • Added Last time table prefix change details.
  • Added maintenance mode feature during table prefix change.

1.2

  • Fixed issues. Tested with 4.2

1.0

  • This is the first version