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:
- your Pendeo sFTP username and password (How to locate your login credentials)
- Your Pendeo database username and password (How to locate your login credentials)
- WordPad or TextEdit (plain text editors usually installed on your computer)
- To export your database (how to “dump” (backup) your WordPress database)
Step by Step Instructions:
-
- Step 1 – Open your exported .sql file in your plain text editor (OSx: TextEdit, Windows: NotePad)
-
- Step 2 – Perform a Search & Replace (OSx: CMD + F, Windows: CNTRL + H). Search for your current table prefix and replace with a random string of characters. Save and exit.
-
- Step 3 – In your Pendeo Control Panel, find the product you want to “Manage”.
-
- Step 4 – Scroll to your MySQL section and click the “Adminer URL”. Login to your Pendeo database.
-
- Step 5 – Create a back-up of your current Pendeo Database.
-
- Step 6 – Go to the root directory of your database, select all and click “Drop”.
-
- Step 7 – Import your recently saved .sql file with your updated table prefix.
-
- Step 8 – Configure your FTP client with your login credentials listed in your Pendeo control panel.
-
- Step 9 – Open your wp-config.php file.
-
- Step 10 – Update your $tableprefix. *Make sure the underscore is there.*
-
- Step 11 – Test your site by logging in to your wp-admin.
Comments
No comments on 'How to change your WordPress Database Table Prefixes.'