Security is a major concern for your online business. Any web-based system is vulnerable to attacks which may cause huge loss depending on your business. If you are really a big business, you may lose your intellectual data or directly the attacker may cause a bad effect on your users or customers.

In case of a WordPress blog like me, it will be a personal disaster that I will be loosing all my hard work. That’s why it is always a good practice to regularly backup your WordPress blog.

Apart from backing up, you have to take few more steps to improve the security of your WordPress blog.

  • For example, you can restrict the login attempts to your WordPress dashboard by avoiding a brute force attack on your blog.

Similarly, the WordPress database has to be protected because that’s the backbone of WordPress CMS. Your WordPress database is one that will be having all the configurations stored, all the posts/pages stored in it.

When someone gets access to it, they can cause any kind of damage to your blog.

  • Re-naming the WordPress database table’s prefix, is one of the simplest ways to postpone an SQL based attack.
  • You read correct, it is about only “postpone” and not a way to”avoid” or “stop” or “prevent”.
  • Even Wordfence had published a detailed article on why changing the database table prefix won’t help in improving security.

First of all, if you want to change your WordPress database prefix, please make sure “why do you want to change it?”

In case, if you are not able to find an answer to this question then think twice before doing it.

The Quick steps to change your WordPress database default prefix to preferred prefix nameToday, I will be taking you through the quick steps to change the WordPress database prefix to something like “vp_” instead of the default “wp_”.

  1. Login to your WordPress dashboard.
  2. Go to Plugin – Add New.
  3. Search for brozzme db prefix, Click on “Install Now” and then “Activate”.
  4. Once Installed, go to Brozzme – DB PREFIX.
  5. Enter your preferred prefix under “New Prefix”. For example, I am changing the db prefix to “vp_”
  6. Click Change DB Prefix. Done.

You can take a look at the below screenshot which clearly shows how to change the database prefix:The exact to change WordPress db prefix

Important points to note while changing database prefix:

  • Make sure you take a full backup of your WordPress database because once you clicked “Change DB Prefix”, you cannot revert the changes if anything breaks.
  • If the prefix change happens smoothly, you can change the prefix any number of times.
  • As mentioned earlier, by changing the DB prefix, there won’t be any improvement in WordPress security instead you are just postponing it.
  • Make sure you have the write permissions for the wp-config file, check here.
  • Learn more about WordPress security here.

Let me know, in case, if you are facing any issues or how else you change the DB prefix.



About the Author:

I love-to-code, passionate-to-write, an upcoming author, and WordPress enthusiast. Here at BlashO, I mostly share WordPress tips. Connect with me @Twitter.

Leave A Comment