WordPress.org

Ready to get started?Download WordPress

Forums

Error - database connection - Host Name (15 posts)

  1. Rikku
    Member
    Posted 9 years ago #

    I have no idea how to get my host name. It keeps coming up as an error, so I am sure that is the problem. I tried going to my CPanel and looking in the MySQL section, but it says the host name is mysql.existhost.com (which is my hosts website). I tried this, but it didn't work. The "localhost" didn't work either. I'm not sure how to get it, I tried looking through the installation, but it said it would give me a php code thing. It didn't. I don't know what to do.

  2. Try following this guide: http://www.tamba2.org.uk/wordpress/cpanel/

  3. vkaryl
    Member
    Posted 9 years ago #

    Check with your host for what to put in there. Did you use Fantastico or install yourself?

  4. moshu
    Member
    Posted 9 years ago #

    In cPanel on the DB admin interface when you add the user to the database it will give you 2 connection strings: one for Peral, one for PHP. Look at the second one - everything should be there.

  5. Rikku
    Member
    Posted 9 years ago #

    I used what my server provided. It doesn't give me any code at all. I don't think I have Perl on my server. It's all so confusing.

  6. moshu
    Member
    Posted 9 years ago #

    Did you read the guide from the link above that macmanx gave you?
    Did you look at the images there? Go back again and take a look at the section titled "Connection Information"...
    If you don't see that on your database management cPanel page - it means you didn't add the user to the DB.

  7. Rikku
    Member
    Posted 9 years ago #

    None of the pictures match up to what I have on my CPanel.

  8. moshu
    Member
    Posted 9 years ago #

    Rikku,
    Don't get lost in details. Your cPanel might have a different skin/theme, the colours might be different etc. but that information is the same.
    Find a link (button) named "MySQL Databases" and clicking on it will take you to the next page where the connection string are displayed.
    Again: if you did NOT add the user to the database, you won't see it. Question: Did you add the user to the database???

  9. Rikku
    Member
    Posted 9 years ago #

    I did add a user to the database. There isn't a link that says that. Only links that take you to the databases I have created. When you click on one of those, it says:
    Host Name: mysql.existhost.com
    Port number (says a number)
    Database name: angela_wordpress
    phpMyAdmin Built in phpMyAdmin control panel
    you will need a properly configured dba user to log in (just add user with dba role if you don't have one)
    Quota Used 0.0 MB out of 25 MB
    Database users: (my username is here)

  10. moshu
    Member
    Posted 9 years ago #

    Quote 1: I did add a user to the database
    Quote 2: you will need a properly configured dba user to log in (just add user with dba role if you don't have one)

    Don't you sense any contradiction here...?
    The user is NOT added to the DB.

  11. Rikku
    Member
    Posted 9 years ago #

    Database users: angela_wordpress
    I added that user to the database already..and I can login to PHP MyAdmin with that username. I think it's the host name...I'll try a new user thing though to see if your right.

  12. moshu
    Member
    Posted 9 years ago #

    Create a user (angela_wordpress) and to ADD to the database are 2 different operations. Well, that's an overstatement... the second one is a click when you see the DB and the user in the proper fields, you click below on the add user button. Note: the fact that you see them in the same line does NOT mean the user was added.

  13. Rikku
    Member
    Posted 9 years ago #

    Alright..I tried a new user..and I specifically picked the "Dba" roll in this drop down menu and clicked "grant". but it still isn't working.

  14. moshu
    Member
    Posted 9 years ago #

    I didn't say grant. I sad "ADD user to db".

  15. Rikku
    Member
    Posted 9 years ago #

    Database users :angela_angela, angela_wordpress
    I granted for both. I looked for an add..or anything else that might do the same thing..but grant is the only thing I can do. It clearly says that I have those two users for the database...I'm starting to give up on this..but thanks so much for trying to help =) It's appreciated.

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags