Can anyone please advise me if there will be any problems changing the wordpress table prefix, after the installation has been completed.
I’m halfway through developing my wordpress website and I would like to change my table prefix to make it a little more secure.
If I go to the wp-config.php and change my prefix, will it break my current install – or will it automatically update the database?
/**
* WordPress Database Table prefix.
*
* You can have multiple installations in one database if you give each a unique
* prefix. Only numbers, letters, and underscores please!
*/
$table_prefix = 'wp_';
I’m not great with databases, and I’m wondering if I need to run a query after I change this…
Thanks in advance for any help.
It won’t automatically work just by changing the prefix in your wp_config.php. That is part of the process, but there are some database changes you need to make too.
Back-up before making any changes to prevent a disaster.
Follow the instructions in the WordPress Codex.
Or, follow this walkthrough if you need help with the specifics of the process.
backup the database first (of course) but as long as the tables in your database match the prefix it should be fine. I.e. if you renamed all the tables wp4_tablename then changed that prefix value in the config file that would work. If you just change the prefix in config without changing your actual table names that will break your site.
There is a plugin can help you easily to change your wordpress table prefix name.
Step1: back up your DB tables or everything.
Step2: install the WordPress plugin :https://wordpress.org/plugins/db-prefix-change/