How to change your WordPress Database Table Prefixes

Changing your WordPress table name prefixes may be required during a migration. Many installations of WordPress use a table prefix of ‘wp_’. Tables beginning with a known prefix like wp_, make it much easier for attackers to maliciously alter your database as they will know the names of all of the WordPress tables. Changing the table prefix to a random string makes it much much harder to execute such an attack.

You will need:

Important: When doing the find and replace step, make sure you only find/replace table prefixes and do not inadvertently replace strings of text which are not table prefixes. This can happen, for example, with Woocomnmerce installations which include a string in the product tables relating to images.

Step by Step Instructions:

Shortlink: