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, you must 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. The Standard WordPress prefix for databases is wp_ and that is the one you want to change.
Solid Security Tool (previous iThemes Security)
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 needed: the new database prefix. The plugin will generate a new one for you. You only have to press the button if you are okay 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 Solid Security in WordPress plugin repository.
- Click the Install button to install Solid Security on your site.
- Click the Activate button to activate this plugin.
https://wordpress.org/plugins/better-wp-security/
Now, go to Dashboard > Security and after you do the onboarding, go to Security > Tools and Run a database prefix change and you’re done.
More Details: Solid Security Change Database Prefix – Solid Help Center
