Support » Installing WordPress » Installation to 3 domains under 1 host

  • Resolved creativegal


    I successfully installed WordPress to one of my domains. If I want to add it to the others, do I need to create a different MySQL username for each domain? Not a tech person, so go easy on me. 🙂 thanks

Viewing 4 replies - 1 through 4 (of 4 total)
  • Actually, it looks like this is the problem: I already have WordPress in use on the one domain. In the instructions, I see this tidbit:

    “If you have only one database and it is already in use, you can install WordPress in it – just make sure to have a distinctive prefix for your tables, to avoid over-writing any existing database table.”

    Can someone please translate into non-techie language — what tables and how and where do I give them a prefix?


    Nevermind, I finally found the info. In case anybody else is looking, it’s here:

    you should use different databases for different domains, how ever if you want to use same database you should change the table prefix in wp-config.php. give different table prefix to each of your wordpress blogs.

    in your wp-config.php, you will find these lines where you will enter the name of user and database and password.

    define('DB_NAME', 'wordpress');     // The name of the database
    define('DB_USER', 'username');     // Your MySQL username
    define('DB_PASSWORD', 'password'); // ...and password

    below few lines there will be
    $table_prefix = 'wp_';
    change it to acc. to your preference like

    $table_prefix  = 'wp1_';
    $table_prefix  = 'wp2_';
    $table_prefix  = 'xxx_';

    table prefix are used to store the content you upload while writing posts and pages and if you keep same prefix it will mess up with other blog’s database tables.
    just remember to give different name to different blog

    its up-to you if you wanna use same user-name or different.

    oh! when you posted the comment, i think i was busy writing it

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Installation to 3 domains under 1 host’ is closed to new replies.