Change WordPress Database Table Prefix
Many WordPress hosts will modify your default database table prefix when setting a site up for you. If you need to reset this to default, or would like to change it on your own, use these steps.
View Database Table Prefix
First you will want to check what your WordPress database table prefix is set to currently.
- Log in to the User Portal
- Select the environment name
- Click phpMyAdmin
- Select the database name
- In the center of the page you will see a list of database tables
- Normally each table (users, usermeta, options, posts, etc) begins with wp_
- In this example you will see the database tables begin with test_
- This means the wp-config.php file must also list the database table prefix is as test_ and not the default of wp_
Log in via SFTP
- Access your website’s files using SFTP
- Locate in the root of your site, the file called wp-config.php
- Open wp-config.php in your favorite text editor
Once the file is opened in your text editor, towards the top, you will see this line:
$table_prefix = 'wp_';
Change this line to reflect your table prefix. For example, if your table prefix was test_, you would change the line of code to this:
$table_prefix = 'test_';
NOTE: Don’t forget the underscore
_ at the end of the prefix!
Once you save the file, you will have successfully edited your table prefix.