Adding a little more security to you WordPress site by changing wordpress prefix to something hacker will never guess….

Here ‘s how…

Backup Backup Backup!

Open up wp-config.php and change

$table_prefix  = 'wp_';


$table_prefix  = 'PREFIX_';

Run these sql commands from your fav client SQL tool or phpmyadmin

RENAME table wp_commentmeta TO PREFIX_commentmeta;
RENAME table wp_comments TO PREFIX_comments;
RENAME table wp_links TO PREFIX_links;
RENAME table wp_options TO PREFIX_options;
RENAME table wp_postmeta TO PREFIX_postmeta;
RENAME table wp_posts TO PREFIX_posts;
RENAME table wp_term_relationships TO PREFIX_term_relationships;
RENAME table wp_term_taxonomy TO PREFIX_term_taxonomy;
RENAME table wp_terms TO PREFIX_terms;
RENAME table wp_usermeta TO PREFIX_usermeta;
RENAME table wp_users TO PREFIX_users;

UPDATE PREFIX_options SET option_name = REPLACE(option_name,'wp_','PREFIX__') WHERE option_name LIKE 'wp_%';

UPDATE PREFIX_usermeta SET meta_key = REPLACE(meta_key,'wp_','PREFIX_') WHERE meta_key LIKE 'wp_%';