Update WordPress Database Prefix

Sometimes the wrong content will display on a WordPress website. This can indicate that the database is pulling from the wrong tables. This article covers how to fix this by editing wp-config.php.

This is useful if the site is displaying a new install or displaying the wrong site content after importing the database.

Related Articles

Find Database Name of WordPress Site
Import WordPress Site Using Softaculous

Update Database Prefix

1. Log into cPanel
2. Navigate to phpMyAdmin, located in the Databases section
   
3. Select the WordPress database
   TIP: If needed, find the database name for the site.
4. Make note of the prefix on all the tables
   EXAMPLE: In this example, the database name is imhkmc6_example and the table prefix is wpw1_.
   
5. In the cPanel, navigate to the File Manager, located in the Files section
6. Navigate to the document root of the site
7. Edit the wp-config.php file
8. Set the $table_prefix value to the correct prefix for the table, including the trailing _ if there is one
   EXAMPLE: $table_prefix = 'wpw1_';
9. Save changes