[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