WordPress.org

Ready to get started?Download WordPress

Forums

pre-installation query (18 posts)

  1. rastamad
    Member
    Posted 9 years ago #

    I am trying to install WordPress in our hosted web server. Already asked our hosting provider about compatibility issues with PhP, MySQL and Apache versions and was assured that there is no problem.

    Using phpMyAdmin, I checked and found a database named in our account. But it says that we don't have privileges to create a new database, which is required for the blog installation (as specified in the detailed instructions). The technical support staff also told me that we can have as many tables as we want but they all have to be in the same database.

    How do I go about this now?

  2. Use the database that you already have access to.

  3. Kafkaesqui

    Posted 9 years ago #

    Follow macmanx advice, but also see this:

    http://codex.wordpress.org/Installing_WordPress#Detailed_Instructions

    Since you have a database, skip down to Step 3.

  4. chuckblue
    Member
    Posted 9 years ago #

    when I install in my domain using cpanel, it creates a database using part of the name of my domain as a prefix. for example drivein-jim.net domain creates mysql db with a prefix of drivein. So a wp install creates drivein_wpx the x being the number of that db.

    It wont let me create one starting with 'wordpress', says it already exists.

  5. rastamad
    Member
    Posted 9 years ago #

    Just to be on the safe side, does this mean I don't need to create a separate database -- or a table in the database -- for WordPress? So what do i provide for db_name, db_user, db_password and db_host in Step 3 if I skipped Step 2?

  6. Kafkaesqui

    Posted 9 years ago #

    The database can have any name. It doesn't need to be "wordpress".

    When you run the install in WordPress, it creates the tables for you in the database.

  7. Kafkaesqui

    Posted 9 years ago #

    db_name: database name
    db_user: username for accessing database
    db_password: password for username for accessing database

  8. Kafkaesqui

    Posted 9 years ago #

    Forgot...

    db_host: the server name (i.e. host) for the MySQL server. Often just "localhost" works, but if not you'll need to get the server name to use from your provider.

  9. rastamad
    Member
    Posted 9 years ago #

    Thanks a lot... =)

  10. rastamad
    Member
    Posted 9 years ago #

    btw, the existing database for our hosted account is named pcijor. Do I just append the same name?

  11. Chyetanya Kunte
    Member
    Posted 9 years ago #

    Depending upon the hosting solutions you choose, there is a limit to the number of MySQL dbs that you can have. My older plan allowed me only one. That said I could still run WordPress and some other apps using the same (only) db, but segregating the db by table prefixes for different apps, there by keeping the data clean and identifiable.

    You could use a prefix like wp_ for all your tables there by distinguishing them as WordPress related tables, and if you plan to use other apps like say phpbb or refer (for example), you could call them by using table prefixes like phpbb_ and refer_ .

    Do pay attention to this detail though. Since the default is so fast that you'll wonder where you missed setting this =)

  12. rastamad
    Member
    Posted 9 years ago #

    Are you saying I shouldn't use the name of the existing database as the db_name for the WordPress installation?

  13. lyklev
    Member
    Posted 9 years ago #

    WordPress allows you to use a prefix, which you can change. All your tables in one database get the prefix you set in wp-config.php. This way you can put more than one wordpress blog in the same database, by setting different prefixes for different blogs.

  14. Chyetanya Kunte
    Member
    Posted 9 years ago #

    Yes you can use the existing name (that's the only option if you cannot have more than one db). Just ensure that the table prefix is wp_ (as shown below):

    $table_prefix = 'wp_';

  15. Chyetanya Kunte
    Member
    Posted 9 years ago #

    Let's say you want to have another blog on your site using the same db, ensure that this time the table prefix is something like:

    $table_prefix ='wp2_';

    or any other name to distibguish other than that you've already used in your database.

  16. rastamad
    Member
    Posted 9 years ago #

    Now I'm really confused. I went ahead using the existing database name for the db_name, supplied a username and password and left localhost as db_host. But I got this error message:

    Error establishing a database connection

    Help please!

  17. Chyetanya Kunte
    Member
    Posted 9 years ago #

    Don't worry nothing has gone wrong. Are you sure your db_name is correct? Sometimes the shared hosting provides add a username prefix to the db_name.

    For example, when I created my db name as wordpress, the db name turned out to be: ckunte_wordpress. If you're still in doubt about the name, try check with your host.

  18. rastamad
    Member
    Posted 9 years ago #

    Great! I finally figured it out. I was able to get through. Thanks guys. =)

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.