该插件尚未通过WordPress的最新3个主要版本进行测试。 当与较新版本的WordPress一起使用时,可能不再受到维护或支持,并且可能会存在兼容性问题。

Brozzme DB Prefix & Tools Addons

描述

Brozzme DB Prefix is a one click tool to modify your database prefix everywhere (database and wp-config.php).

To apply a new prefix, you just need to verify that the wp-config.php is writable and that the Alter rights of the database are enable.

A single entry is need : the new database prefix. The plugin will generate a new one for you. You only have to press the button if you are ok with the generated prefix. Of course, the prefix can be modify to fit your needs.

This plugin doesn’t have any options settings.

Since 1.3 : New tools will be add !

  • mysql dump : export whole database in a single click or more click if you need options 😉

Have a look to the other Brozzme plugins search : Brozzme

Link to Brozzme and WPServeur.

屏幕截图

  • english tool control screenshot-1.png.
  • french tool control screenshot-2.png.

安装

  1. Upload “Brozzme DB Prefix” to the “/wp-content/plugins/” directory.
  2. Activate the plugin through the “Plugins” menu in WordPress.
  3. Go to Tools menu and choose DB Prefix

常见问题

A question that someone might have

An answer to that question.

Why do I need to change the WordPress database prefix ?

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.

What do I need to verify before changes ?

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.
What can I do if the process fails ?

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.
Why can I not do it manually?

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
I can’t delete, edit anymore using phpmyAdmin with MAMP…

Only use lower-case characters to solve this.

评价

2021年7月6日
Installed, changed the database prefix, and removed the plugin in like 1 minute. Worked great.
2021年5月9日
I had a problem with my wp-config file and it couldn’t be writable and I didn’t have the time to change all the database by myself then I used some plugin who would’ve just said to your file isn’t writable….but this plugin changed all the database & I just had to edit wp-config file! Good job & THANK YOU
2020年10月25日
I recently migrated a WordPress site for a non-profit site and noticed the site tables didn't have a unique table prefix. To help ensure the site is more secure, I wanted to add a unique table prefix, but I'm not adept at using mySQL. This plugin literally just worked. I created a backup of the database (just in case), installed it, activated it, and clicked the button. The update happened instantly and I verified things were updated by going into the mySQL console. Thank you for doing the heavy lifting for our nonprofit (and me)!
阅读所有28条评价

贡献者及开发者

“Brozzme DB Prefix & Tools Addons” 是开源软件。 以下人员对此插件做出了贡献。

贡献者

更新日志

1.2

  • get right path to wp-config -thx @victorfreitas

1.1

  • bugfixes with languages txt domain

1.0

  • Initial release.