[Lesson 6] Change Database Prefix To Protect WordPress Database

WordPress database is another important container where all your crucial information/data sits. Quite obviously, this makes it a desired target. By default, wpdb contains 11 tables which include tables for – users data, site URLs, posts, pages, comments, etc.

Change prefix Manually by SQL command

Step 1 – Go to your WordPress root directory and open wp-config.php file.

Step 2 – Run SQL queries as follows-

RENAME table `wp_commentmeta` TO `astra_commentmeta`;

RENAME table `wp_comments` TO `astra_comments`;

RENAME table `wp_links` TO `astra_links`;

RENAME table `wp_options` TO `astra_options`;

RENAME table `wp_postmeta` TO `astra_postmeta`;

RENAME table `wp_posts` TO `astra_posts`;

RENAME table `wp_terms` TO `astra_terms`;

RENAME table `wp_termmeta` TO `astra_termmeta`;

RENAME table `wp_term_relationships` TO `astra_term_relationships`;

RENAME table `wp_term_taxonomy` TO `astra_term_taxonomy`;

RENAME table `wp_usermeta` TO `astra_usermeta`;

RENAME table `wp_users` TO `astra_users`;

Step 3 – Rename the wp_fields in the tables.

Change prefix with the help of a plugin

Step 1 – Install ‘Change Table Prefix’ plugin

Step 2 – Navigate to ‘Settings’ on your wp dashboard>change table prefix

Step 3 – Enter custom prefix

Psst! Hi there. We’re Astra.

We make security simple and hassle-free for thousands
of websites and businesses worldwide.

Our suite of security products include firewall, malware scanner and security audits to protect your site from the
evil forces on the internet, even when you sleep.

earth spiders cards bugs spiders

Made with ❤️ in USA France India Germany