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

19 May 2022
Note you may have to change the table prefix in wp_config.php yourself but that's no great problem. Great plugin, thank you.
15 September 2021
Database prefixes was done right. wp-config.php file had to do manually, after almost got heart attack when site stooped working.
31 July 2021
I tried on WP Version 5.8. When it finished I had a fresh install of WP. All my content was gone. (I did back up my site so was able to restore it with no problem). Not sure if I did something wrong. ....Just make sure to back up your site before trying.
Read all 55 reviews

Contributors and 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