How to Change the WordPress Database Prefix to Improve Security - Best Webhosting

ULTRAFAST, CHEAP, SCALABLE AND RELIABLE! WE STRONGLY RECOMMEND ACCU WEB HOSTING COMPANY

Watch Wordpress WPBeginner Video: How to Change the WordPress Database Prefix to Improve Security.
Your WordPress database is the control center for your entire site because all of your information is stored there. Some people may try to hack your site if they know the database name. In this video, we will show you how to change the WordPress database prefix to improve your site’s security.

If you liked this video, then please Like and consider subscribing to our channel for more WordPress videos.

Text version of this tutorial:
http://www.wpbeginner.com/wp-tutorials/how-to-change-the-wordpress-database-prefix-to-improve-security/

Follow us on Twitter:
http://twitter.com/wpbeginner

Checkout our website for more WordPress Tutorials
http://www.wpbeginner.com/

Summary of this Tutorial:

Start by making a backup of your database.

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

Look for the table prefix and change it to something different

Now go to phpmyadmin and change the table names

Either click each table or copy the code below to update all of your tables.

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

You may need to edit tables created by any plugins.

Next query the option table and select everything with a name starting with wp_ using the query below.

SELECT * FROM `wp_a123456_options` WHERE `option_name` LIKE '%wp_%'

As well for the usermeta table with a meta_key using wp_ using the query below and change to your new prefix

SELECT * FROM `wp_a123456_usermeta` WHERE `meta_key` LIKE '%wp_%'

Related Links:

How to do a database backup

http://www.wpbeginner.com/beginners-guide/how-to-make-a-wordpress-database-backup-manually/

Published: Sunday, August 11, 2019 9:36 AM
Category: Wordpress WPBeginner

90 Views

Related Videos

WordPress Salts, Unique Keys & Database Prefix - WP Hack Prevention & Security | WP Learning Lab

by Best Webhosting Added 4 years ago 90 Views / 0 Likes

Grab Your Free 17-Point WordPress Pre-Launch PDF Checklist: http://vid.io/xqRL Download our exclusive 10-Point WP Hardening Checklist: http://bit.ly/10point-wordpress-hardening-checklist WordPress Salts, Unique Keys & Database Prefix - WP Hack Prevention & Security | WP Learning Lab In this tutorial I show you how to add WordPress unique keys and salts to your WP-Config.php file and how to change the WordPress database prefix. Both of these are import
WordPress. How To Change Database Tables Prefix In SQL File

by Best Webhosting Added 4 years ago 94 Views / 0 Likes

This Tutorial Will Show You How To Change Database Tables Prefix In SQL File. Build Your WebSite With WordPress Themes From TemplateMonster.com: http://www.templatemonster.com/wordpress-themes.php?utm_source=YoutubeM&utm_medium=video&utm_campaign=wprftk
WordPress. How To Change Database Tables Prefix (If Necessary) And Import SQL File

by Best Webhosting Added 4 years ago 79 Views / 0 Likes

In this tutorial you will learn how to change database tables prefix (if necessary) and import SQL file in WordPress. Choose your WordPress template now: http://www.templatemonster.com/wordpress-themes.php?utm_source=youtube&utm_medium=link&utm_campaign=wptuts138 Want to Build WordPress Site in 5 Hours? Subscribe to this course: http://www.templatemonster.com/website-5-days.php?utm_source=youtube&utm_medium=link&utm_campaign=wptuts138 TOP WordPress Th
Popular
WordPress. How To Change Database Tables Prefix Via Admin Panel

by Best Webhosting Added 4 years ago 102 Views / 0 Likes

This tutorial is going to show you how to change database tables prefix via admin panel. We've transcribed this video tutorial for you here: https://www.templatemonster.com/help/wordpress-change-database-tables-prefix-via-admin-panel.html To view more our WordPress templates go to website: http://www.templatemonster.com/wordpress-themes.php?utm_source=youtube&utm_medium=link&utm_campaign=wptuts463 TOP WordPress Themes: https://www.youtube.com/playlist
Change DB Prefix WordPress Plugin - Secure Your WordPress MySQL Database | WP Learning Lab

by Best Webhosting Added 4 years ago 85 Views / 0 Likes

Grab Your Free 17-Point WordPress Pre-Launch PDF Checklist: http://vid.io/xqRL Download our exclusive 10-Point WP Hardening Checklist: http://bit.ly/10point-wordpress-hardening-checklist Change DB Prefix WordPress Plugin - Secure Your WordPress MySQL Database | WP Learning Lab In this tutorial I'm going to show you how to use the Change DB Prefix WordPress plugin to improve MySQL database security. Anyone running a WordPress-based website needs to con
Joomla 3.x. How To Change Database Table Prefix In Sql File

by Best Webhosting Added 4 years ago 86 Views / 0 Likes

This tutorial will show you how to change the database table prefix in SQL file in Joomla 3.x. To View More Our Joomla Templates Go to Website: http://www.templatemonster.com/joomla-templates.php?utm_source=youtube&utm_medium=link&utm_campaign=jootuts152 More Joomla Tutorials: http://www.templatemonster.com/help/cms-blog-templates/joomla/joomla-tutorials/ Subscribe Our Channel: https://www.youtube.com/user/TemplateMonsterCo/ Follow us: Facebook https:
PrestaShop 1.6.x. How To Change Database Tables Prefix In Dump.sql File

by Best Webhosting Added 4 years ago 88 Views / 0 Likes

This tutorial is going to show you how to change database tables prefix in dump.sql file in your PrestaShop template. Choose your PrestaShop template now: http://www.templatemonster.com/prestashop-themes.php?utm_source=youtube&utm_medium=link&utm_campaign=prshoptuts252 More PrestaShop Video Tutorials: https://www.youtube.com/playlist?list=PLhQIfRNfwAocQcTfOyM0j3LfsskZ3Ip7E Subscribe Our Channel: https://www.youtube.com/user/TemplateMonsterCo/ Follow u
PrestaShop 1.6.x. How To Change Database Tables Prefix (If Necessary) And Import SQL File

by Best Webhosting Added 4 years ago 99 Views / 0 Likes

This tutorial shows how change database tables prefix and import SQL file in PrestaShop 1.6.x. Choose your PrestaShop template now: http://www.templatemonster.com/prestashop-themes.php?utm_source=youtube&utm_medium=link&utm_campaign=prshoptuts111 More PrestaShop Video Tutorials: https://www.youtube.com/playlist?list=PLhQIfRNfwAocQcTfOyM0j3LfsskZ3Ip7E Subscribe Our Channel: https://www.youtube.com/user/TemplateMonsterCo/ Follow us: Facebook https://www
PrestaShop 1.6.x. How To Change Database Tables Prefix (If Necessary) And Import SQL File

by Best Webhosting Added 4 years ago 93 Views / 0 Likes

This tutorial is going to show you how to change database tables prefix if necessary and import SQL file. We've transcribed this video tutorial for you here: https://www.templatemonster.com/help/prestashop-1-6-x-how-to-change-database-tables-prefix-if-necessary-and-import-sql-file.html More Premium PrestaShop templates: http://www.templatemonster.com/prestashop-themes.php?utm_source=youtube&utm_medium=link&utm_campaign=prshoptuts305 More PrestaShop Tu
Popular
iThemes Security Walkthrough - Improve WordPress Security Step-by-Step

by Best Webhosting Added 4 years ago 113 Views / 0 Likes

Grab Your Free 17-Point WordPress Pre-Launch PDF Checklist: http://vid.io/xqRL iThemes Security Walkthrough - Improve WordPress Security Step-by-Step https://youtu.be/n0P3G1ZMETI iThemes Security has over 30 modules that help you secure your site or your client sites really easily. It's all point and click making WordPress security really easily. Grab your free 17-Point WordPress Pre-Launch PDF Checklist: http://vid.io/xqRL Download your exclusive 10-
WordPress Table Prefix - How & Why To Change It | WP Learning Lab

by Best Webhosting Added 4 years ago 92 Views / 0 Likes

Grab Your Free 17-Point WordPress Pre-Launch PDF Checklist: http://vid.io/xqRL Download our exclusive 10-Point WP Hardening Checklist: http://bit.ly/10point-wordpress-hardening-checklist WordPress Table Prefix - How & Why To Change It | WP Learning Lab In this tutorial I'm going to show you to change your WordPress Table Prefix. There are two ways. One is to make the change in the wp-config.php file when you are installing WordPress. In the wp-config.
Drupal 7.x. How To Apply Snapshot To Installed Drupal Engine With Custom Database Prefix

by Best Webhosting Added 4 years ago 92 Views / 0 Likes

This tutorial shows how to apply snapshot to installed Drupal engine with custom database prefix. To view more our Drupal templates go to website: http://www.templatemonster.com/drupal-themes.php?utm_source=youtube&utm_medium=link&utm_campaign=druptuts42 More Drupal Tutorials: https://www.templatemonster.com/help/cms-blog-templates/drupal/drupal-tutorials/ Subscribe Our Channel: https://www.youtube.com/user/TemplateMonsterCo/ Follow us: Facebook https