9 {{ upvoteCount | shortNum }}
9 {{ upvoteCount | shortNum }}

Need Help Manually Installing Wordpress MySQL Prefix Correctly

by highbids
7 replies
I previously installed wordpress using my host software installer & I ran
a plugin called WP Security Scan & It told me that I needed to change my
table prefix which I then tried to & could not get it to do it.

I uninstalled wordpress & I am now manually installing it
by using wordpress instructions at there website.

Installing WordPress « WordPress Codex

I've already created my MySQL database using the database wizard & there was
nothing in it for me to setup my own table prefix.

I don't want to go any further & have to go thru all this again how do
I setup a secure table prefix to keep a SQL injections from happing.
#correctly #installing #manually #mysql #prefix #wordpress
  • Profile picture of the author highbids
    I used the MySQL® Database Wizard & I didn't see the option
    to specify the db prefix.

    I just checked the the regular MySQL database section & no where in both
    do I see a place to set the db prefix all I've seen is a section for the database
    name, username & password where is the db prefix area.
    {{ DiscussionBoard.errors[3169106].message }}
  • Profile picture of the author somacorellc
    [DELETED]
    {{ DiscussionBoard.errors[3169508].message }}
    • Profile picture of the author highbids
      Stable Host

      Originally Posted by somacorellc View Post

      who are you hosted with? Most hosts nowadays require a prefix for adding databases.
      {{ DiscussionBoard.errors[3169834].message }}
  • Profile picture of the author SteveJohnson
    Good grief. Why are you people giving advice about something you obviously know nothing about?

    Highbids:
    If you know how to drop the existing tables in your MySQL database, do that now. Caution - I'm assuming this is a new installation. This WILL destroy any existing data.

    After dropping the tables, you should have a clean database with no tables.

    Now you'll need to edit your wp-config.php file. This is the file where you entered your database information - username, password, etc.

    A few lines below where you entered the authorization keys and salts is this line:
    $table_prefix = 'wp_';

    The 'wp_' part is what the security scanner is telling you to change. Replace wp_ with a new value (making sure to leave the single quote marks and semi-colon), save the config file, upload to your server, then restart the WordPress install.
    Signature

    The 2nd Amendment, 1789 - The Original Homeland Security.

    Gun control means never having to say, "I missed you."

    {{ DiscussionBoard.errors[3172282].message }}
    • Profile picture of the author highbids
      Steve,

      Do I still need to drop the database, I created a totally new
      one just for this blog before the manual install of wordpress.

      I setup the table prefex correctly WP Security Scan is not
      warning me any more I set it up like this $table_prefix = '1h7k';

      One thing I didn't do is setup authorization keys do you think
      I still need to do this is it that important.

      Originally Posted by SteveJohnson View Post

      Good grief. Why are you people giving advice about something you obviously know nothing about?

      Highbids:
      If you know how to drop the existing tables in your MySQL database, do that now. Caution - I'm assuming this is a new installation. This WILL destroy any existing data.

      After dropping the tables, you should have a clean database with no tables.

      Now you'll need to edit your wp-config.php file. This is the file where you entered your database information - username, password, etc.

      A few lines below where you entered the authorization keys and salts is this line:
      = 'wp_';

      The 'wp_' part is what the security scanner is telling you to change. Replace wp_ with a new value (making sure to leave the single quote marks and semi-colon), save the config file, upload to your server, then restart the WordPress install.
      {{ DiscussionBoard.errors[3173670].message }}
      • Profile picture of the author SteveJohnson
        Originally Posted by highbids View Post

        Steve,

        Do I still need to drop the database, I created a totally new
        one just for this blog before the manual install of wordpress.

        I setup the table prefex correctly WP Security Scan is not
        warning me any more I set it up like this = '1h7k';

        One thing I didn't do is setup authorization keys do you think
        I still need to do this is it that important.
        No need to drop the database if you started out with a clean one, i.e., empty with no tables.

        You definitely DO need to set up the authorization keys as they're an important part of keeping your WP secure. Open your wp-config.php file, scroll down to the keys section. You'll see a url there. Paste that in a browser window. You'll see a list of randomly-generated keys that you can just copy and paste right into your config file.
        Signature

        The 2nd Amendment, 1789 - The Original Homeland Security.

        Gun control means never having to say, "I missed you."

        {{ DiscussionBoard.errors[3175326].message }}
  • Profile picture of the author highbids
    Steve,

    Thanks for the reply one last question what length should my
    sql database password be.
    {{ DiscussionBoard.errors[3175884].message }}
    • Profile picture of the author SteveJohnson
      Originally Posted by highbids View Post

      Steve,

      Thanks for the reply one last question what length should my
      sql database password be.
      I would make it at least 8 characters, I like to use 10-12. Use a combination of upper- and lower-case letters, numbers, and punctuation characters like ( ) - _ + ! #. You don't want to use a combination of characters that can be found in a dictionary.

      Use the same guidelines for your WordPress password - even your username, if you want to be fanatical.
      Signature

      The 2nd Amendment, 1789 - The Original Homeland Security.

      Gun control means never having to say, "I missed you."

      {{ DiscussionBoard.errors[3176257].message }}

Trending Topics