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

I just tried this plugin and it worked perfectly.

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

Be AWARE: it does only HALF the job, but can be fixed.

Plugin works for updating the prefix of the database tables, but you have to manually adjust your prefix in the wp-config.php file. I tested it with WP5.2 and the file permissions of wp-config.php temporarily set to "777". Despite of that, the wp-config-file did not get updated. Not big of a deal, after changing the prefix myself in the wp-config-file, everything worked just fine (i.e. my site was not "broken" anymore)
Read all 43 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.

Changelog

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