How to Change the WordPress Database Prefix to Improve Security



Your WordPress database is the management middle in your complete web site as a result of your whole info is saved there. Some folks could attempt to hack your web site in the event that they know the database title. In this video, we are going to present you ways to change the WordPress database prefix to enhance your web site’s safety.

If you preferred this video, then please Like and think about subscribing to our channel for extra WordPress movies.

Text model of this tutorial:

Follow us on Twitter:

Checkout our web site for extra WordPress Tutorials

Summary of this Tutorial:

Start by making a backup of your database.

Then go to your root listing and fid wp-config.php

Look for the desk prefix and alter it to one thing completely different

Now go to phpmyadmin and alter the desk names

Either click on every desk or copy the code under to replace your whole tables.

RENAME desk `wp_commentmeta` TO `wp_a123456_commentmeta`;
RENAME desk `wp_comments` TO `wp_a123456_comments`;
RENAME desk `wp_links` TO `wp_a123456_links`;
RENAME desk `wp_options` TO `wp_a123456_options`;
RENAME desk `wp_postmeta` TO `wp_a123456_postmeta`;
RENAME desk `wp_posts` TO `wp_a123456_posts`;
RENAME desk `wp_terms` TO `wp_a123456_terms`;
RENAME desk `wp_term_relationships` TO `wp_a123456_term_relationships`;
RENAME desk `wp_term_taxonomy` TO `wp_a123456_term_taxonomy`;
RENAME desk `wp_usermeta` TO `wp_a123456_usermeta`;
RENAME desk `wp_users` TO `wp_a123456_users`;

You may have to edit tables created by any plugins.

Next question the choice desk and choose every little thing with a reputation beginning with wp_ utilizing the question under.

SELECT * FROM `wp_a123456_options` WHERE `option_name` LIKE ‘%wp_%’

As properly for the usermeta desk with a meta_key utilizing wp_ utilizing the question under and alter to your new prefix

SELECT * FROM `wp_a123456_usermeta` WHERE `meta_key` LIKE ‘%wp_%’

Related Links:

How to do a database backup

source WordPress Tutorial

Leave a Reply

Your email address will not be published. Required fields are marked *