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_%’
How to do a database backup