The below mentioned steps will describe the procedure to
Change WordPress Database Table Prefix.
#1. Change Table Prefix from File Manager
- Login to cPanel and go inside File Manager section.
- Get into WordPress installation directory.
- Right click over the wp-config.php file and then Edit.
- The editor page will open. Locate the line with $table_prefix = ‘wp’;
- Replace the table prefix wp with the one you want.
- Click over Save Changes.
#2. Change Table Prefix from phpMyAdmin
- Go inside phpMyAdmin section in cPanel.
- Check all to select all the tables and click over With Selected and then select Replace Table Prefix from the list of options.
- A window will appear. In the FROM section, enter the old prefix and in the TO section, the new one.
- Click over Continue to save the changes.
- Click over GO to complete.
That’s It !
Refer to the
blog to read in-detailed procedure.
