How to change database prefix in WordPress
October 1, 2021
Almost everything that you do in WordPress is stored in databases. Your new plugins will use a database as well as the core WordPress system. Since databases contain all your information, it is important that you do everything you can to make it more secure.
Because more often than not, hackers use bots to search for security flaws in your website, it is not a good idea to have a default database name and prefix for your WP database.
If you had installed WordPress by yourself, you will remember that you had to input database information like the name of your new database, username, and a database prefix. Standard WordPress prefix for databases is wp_ and that is the one you want to change.
iThemes Security Tool
To apply a new prefix, you just need to verify that the wp-config.php is writable and that the Alter rights of the database are enable.
A single entry is need : the new database prefix. The plugin will generate a new one for you. You only have to press the button if you are ok with the generated prefix. Of course, the prefix will be added randomly.
- Go to the WordPress dashboard.
- Go to the ‘plugins’ tab and click on ‘add new.’
- Search iThemes Security in WordPress plugin repository.
- Click the Install button to install iThemes Security on your site.
- Click the Activate button to activate this plugin.
Now, go to Dashboard > Security and after you do the onboarding, go to Security > Settings > Tools and Run a database prefix change and you’re done.