Become Wordpress Professional - Your Ultimate Wordpress Guide

Monday, 18 March 2013

How to Increase Database security in WordPress

securing wordpress database
As the world most popular blogging software WordPress is the huge target of malicious scripts, hacks and spams and one of the best way to secure your WordPress database is to change the Default Table Prefix and in this tutorial you will learn how to do this quickly and easily during the WordPress installation Process.

You May also like : Guide to install Wordpress

Lookout the Default Database Prefix

Go to your online web host and there you search phpMyAdmin

Location of phpMyAdmin in Cpanel
Location of phpMyAdmin in your Cpanel

Here you will see WordPress table prefixes with wp_ . The WordPress table used as default values are heavily targeted by bad bots and malicious scripts. So by changes the default prefixes and set as unique can effectively immunize your Database with such automated attacks and bad boys. 

Default WordPress Database Prefix
Default WordPress Database Prefix

How to Change default Database Prefix in WordPress

The easiest and recommended method to change the default prefix happens is before the installation process. Before submitting the setup page go to your online web host Cpanel and then WordPress site directory and open wp-config.php and scroll down where it say ' WordPress Database Table Prefix ' . Here you see the default prefix wp_ . 

Default WordPress Database Prefix
Default WordPress Database Prefix

Changing this prefix to anything different is going to work just fine and perfectly save to include wp_ is not as long the entire prefix but even so there are three helpful tips for customizing your own database prefix

  1. Begin the prefix with wp_ so the table appears in order among other tables that are edit by plugins and themes. 
  2. In the middle pick any sequence of random alphanumeric characters.
  3. At the end of prefix with an underscore _ so that the actual table names for example host, users, metadata and so forth stand out under easily recognized.
Return to your Web host Cpanel and Go to WordPress site directory and open wp-config.php and in ' WordPress Database Table Prefix ' search $table_prefix = 'wp_' ; and edit this as

$table_prefix = 'wp_write random Alpha numeric characters_' ;

Example : $table_prefix = 'wp_s3CUr3_' ;

New Database Prefix with addition of Random Characters
New Database Prefix with addition of Random Characters

as the new prefix and save the file and after this point install WordPress in your site and complete the installation. Now again go to phpMyAdmin and you will see default DB prefix changed into new random prefixes.

New DB Prefix phpMyAdmin
New DB Prefix phpMyAdmin

Now everything looks great and all of your tables and Prefix are more secure. Note that if you already setup a WordPress and want to change prefix its still possible and you will learn in our coming tutorials. Changes the DB prefix during the WordPress installation process is much easier. The point is that by using the using the things other than default prefix can protect your database from majority of automated attacks. 


Post a Comment

Please Avoid Spamming. Comments will be moderated before they are published.