Brozzme DB Prefix & Tools Addons

An answer to that question.

WordPress Database is like the heart for your WordPress site, as the database runs for every single information store, you need to protect it against hackers and spammers that could run automated code for SQL injections. Many people forget to change the database prefix in the install wizard. This makes it easier for hackers to plan a mass attack by targeting the default prefix wp_. To avoid them, you can protect your database by changing the database prefix which is really easy with Brozzme DB Prefix. It takes a few seconds to change the prefix.

MAKE SURE YOU HAVE A DATABASE BACKUP BEFORE USING THIS TOOL. You just need to verify:

• wp-config.php is writable on your server.
• that mySQL ALTER rights are enable.

Depending on where the fail occurs: Compare prefix in the wp-config.php and in phpmyAdmin, depending on the the situation, - change manually $table_prefix value in wp-config.php. - suppress all tables and import the backup in phpmyAdmin. Verify all the pre-requisite point in the previous question before processing once again.

Of course you can, but there's many occurences to modify to make it works. Not only the tables name need to be modify. Here is the exhaustive list of what to change, - Tables names, - table options: {old_prefix}user_roles option name, table usermeta, for each registered user, {old_prefix}capabilities and {old_prefix}user_level, option names if exists you'll need to also modify {old_prefix}dashboard_quick_press_last_post_id option name

Only use lower-case characters to solve this.