MySql

  • I have a server with the addon domain feature in cpanel. I have one WP addon domain presently on this server already using one Mysql db and I want to add another WP to be on a second addon domain.
    Question: Can I add another user and db to Mysql? I can’t seem to be able to do this. The server docs say I have many Mysql db that can be added so it’s not a problem is having only one db.
    Thanks!
    knotty

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

  • Multiple installations of WP can use the same database by using a different db prefix. Simply copy your existing wp-config.php from the WP installation that uses your current db, open it in a text editor, and change the wp_ (or whatever it current is) in $table_prefix = 'wp_'; to something different.

    Thread Starter knotty

    (@knotty)

    Ok, thanks! I didn’t know about using the same db. I was assuming I had to make another separate db and user.
    knotty

    Thanks for the information about multiple installation of WP with respect to MySQL database.

    Thread Starter knotty

    (@knotty)

    Ok, things are working good. Tried making another user for the one db and that worked good. I went ahead and made a separate Mysql database since my host offers unlimited db’s either way they both work fine.
    Thanks!

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘MySql’ is closed to new replies.