How Do I Setup The Table Prefix For My SQL Database For WordPress

  • I’m doing a manual install of wordpress & have already setup my MySQL
    database using the database wizard & nowhere in the database setup was
    there a way for me to pick my own table prefix.

    I previously installed wordpress using my hosts software installer & then used the plugin “WP Security Scan” & it warned me about the table prefix wp_ needing changed.

    I’m trying to set it up correctly the first time to prevent SQL injection attacks from being performed.

    I emailed my host & they said that wordpress sets it up on it’s own I know it does wp_

    How can I set it up correctly the 1st time during the manual install it’s a pain to change once it’s setup wrong.

Viewing 5 replies - 1 through 5 (of 5 total)

  • Look in wp-config at line 62.

    $table_prefix = 'wp_';

    While you are there entering your database information, you can change the table prefix prior to installing wordpress.

    Thread Starter meakerseeker

    (@meakerseeker)

    Would this be correct

    $table_prefix = ‘wp_’; (Original)

    $table_prefix = ‘wp_mydatabase’; (Mydatabase)

    The ‘wp_’ prefix is what you are trying to change, so technically, any variation of that is changing it. When I change mine I just use a couple of random numbers and letters followed by an underscore, for example:

    $table_prefix = '6et2_'; – or – $table_prefix = '2r_93d_';

    Something along those lines.

    Just make sure to limit it to numbers, letters and underscores, and you should probably avoid actually using the name of your database. All you are really trying to accomplish is changing the table prefix from the default wp_ to something less common to add a little more obscurity.

    Thread Starter meakerseeker

    (@meakerseeker)

    Thanks clayton that’s much appreciated.

    You’re welcome.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘How Do I Setup The Table Prefix For My SQL Database For WordPress’ is closed to new replies.