WordPress.org

Ready to get started?Download WordPress

Forums

iThemes Security (formerly Better WP Security)
[resolved] [Plugin: Better WP Security] Database prefix name changed broke my site :( (5 posts)

  1. KovaZg
    Member
    Posted 2 years ago #

    Today I made backup of database, and tried to rename table prefix.
    Site works, but if you go directly to topic, if you open site to home page, it redirects to /wp-admin/install.php :(

    I will try to restore database back to old version. But if there is solution for this, I would rather have prefix database changed. Thanks.

    http://wordpress.org/extend/plugins/better-wp-security/

    After while:
    Deactivated some plugins, Wp total Cache for example, re-activated, cleared cache, and now it works.
    Sorry to be so fast on trigger. Thanks.

  2. Sabir Abdul Gafoor
    Member
    Posted 2 years ago #

    Hi,
    I have same kind of problem but I solved by editing the wp-config file with newly create table prefix.

    eg: When you click on the database table prefix change button, then it change the table prefix with random generated its own, At the same time the wp-config file don't have the write permission.( For security reason Wp-config file is not editable by wp security). So you have to do the manually by editing the wp-config file with random generated database table prefix.

    This work for me.

  3. @KovaZg Glad it works. This makes me think I'll include a checker for the cache in the future.

    @sabirtiger Did you allow it to change core files?

  4. 702arts
    Member
    Posted 1 year ago #

    Hi. I was having problems with logging into my website. I have better wp security installed and a login lockdown plugin as well. I tried to reset the password and that didn't work. I tried deleting the plugins and that didn't work. I tried going into the database and resetting the password and that didn't work. I noticed that the database table prefixes were renamed by the plugin and that's about as far as my knowledge will allow me to mess things up.

    Do you have any recommendations as to resetting wordpress to default and clearing out the plugin changes? Even if I export the posts, they have a new prefix name, so re-installing wordpress, then importing the post data, would be another mess.

    Any recommendations.

  5. PrincessFaissl
    Member
    Posted 1 year ago #

    702arts,

    Did you check to see what the DB_PREFIX was set to in the wp_config.php file? It should match the new table prefix in the database.

    You must allow BetterWPSecurity to have privileges to change the core files; otherwise, you'd need to manually update the wp_config.php files. The default table prefix is "wp_" and would look like this in your wp-config.php file:

    /**
    * WordPress Database Table prefix.
    *
    * You can have multiple installations in one database if you give each a unique
    * prefix. Only numbers, letters, and underscores please!
    */
    $table_prefix = 'wp_icy';

    You can change the prefix to anything...say "wp_34AxZy_", and set it to:

    $table_prefix = 'wp_34AxZy_';

    I just set it to allow BetterWPSecurity to modify core files.

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic

Tags

No tags yet.