Forums

Can’t select database error for GoDaddy hosting (12 posts)

  1. eternaldream
    Member
    Posted 2 months ago #

    So I signed up for an account on godaddy.com. I chose the one for $15 a year, just because it's just for a class. I am having a hard time trying to install Wordpress. Here are all the steps I've taken so far. The site is http://www.tftblog.org by the way.

    For the wp-config file, I made sure to put in the correct host names and such. Here's what it looks like:

    // ** MySQL settings - You can get this info from your web host ** //
    /** The name of the database for WordPress */
    define(’DB_NAME’, ‘My DB name as it appears on the account manager’);

    /** MySQL database username */
    define('DB_USER', 'my user name');

    /** MySQL database password */
    define('DB_PASSWORD', 'my password');

    /** MySQL hostname */
    define('DB_HOST', 'copied from the account manager, it's a string of text and numbers with hostedresource.com at the end');

    Now, are the 'DB_USER' things supposed to be there? Or should it just be my "user name" in the parenthesis?

    I use FTP Surfer to upload everything to my site. And I put in the information, and it's able to connect. So I dragged and dropped all the Wordpress files onto my site, on the top most level.

    At first it wouldn't load the page at all, but I switched the thing to Linux instead of Windows on the configurations, and now I get this new message. When it comes up it has a GoDaddy header on top, that says it's hosted for free. Then it says:

    Can’t select database

    We were able to connect to the database server (which means your username and password is okay) but not able to select the DB_NAME database.

    * Are you sure it exists?
    * Does the user "my user name" have permission to use the DB_NAME database?
    * On some systems the name of your database is prefixed with your username, so it would be like username_DB_NAME. Could that be the problem?

    If you don't know how to setup a database you should contact your host. If all else fails you may find help at the WordPress Support Forums.

    So I tried typing my user name different ways, like it said. But still, nothing. And I made sure to see that the names matched those found in my account pages. So I have no idea what to do now. I tried looking around at similar problems, but I haven't found any solutions. Can anyone help?

  2. samboll
    moderator
    Posted 2 months ago #

    We were able to connect to the database server (which means your username and password is okay) but not able to select the DB_NAME database.

    make double sure the DB name (it can't really be DB_NAME) is correct and you have given your user ALL permissions

  3. eternaldream
    Member
    Posted 2 months ago #

    Well, I made my DB name the same as my user name. So that is what I used for it. How do I give permissions to my user though?

  4. samboll
    moderator
    Posted 2 months ago #

    http://www.tftblog.org/wp-admin/
    read the 1st line of the error page

    it says you have this in wp-config.php
    define('DB_NAME', 'DB_NAME');

    obviously that can't be correct
    the error also states your user name, so if you did name them the same your line in wp-config.php should look like this
    define('DB_NAME', 'lucidfox13');

  5. MichaelH
    moderator
    Posted 2 months ago #

    With Godaddy, you are NOT afforded the opportunity to give a user rights to the database. Godaddy does that for you 'automatically'.

    Also note that WordPress doesn't work well with Godaddy's 'free with domain' type accounts. Also Godaddy 'Windows' hosting doesn't do well with WordPress so if you are using a Windows plan, switch to a linux hosting plan.

    Related:
    Installing WordPress

  6. eternaldream
    Member
    Posted 2 months ago #

    Okay, I don't know what I did. I played around with the database names, and now I got this error message:

    Error establishing a database connection

    This either means that the username and password information in your wp-config.php file is incorrect or we can't contact the database server at lucidfox13.db.4997594.hostedresource.com. This could mean your host's database server is down.

    * Are you sure you have the correct username and password?
    * Are you sure that you have typed the correct hostname?
    * Are you sure that the database server is running?

    If you're unsure what these terms mean you should probably contact your host. If you still need help you can always visit the WordPress Support Forums.

  7. bumblebee23
    Member
    Posted 2 months ago #

    wow i'm glad someone already has the same question. thanks in advance.
    This either means that the username and password information in your wp-config.php file is incorrect or we can't contact the database server at lucidfox13.db.4997594.hostedresource.com. This could mean your host's database server is down.

    * Are you sure you have the correct username and password?
    * Are you sure that you have typed the correct hostname?
    * Are you sure that the database server is running?

  8. chandlerwhite
    Member
    Posted 1 month ago #

    I posted this about four hours ago. GoDaddy gave me fits.

    Wanted to pass this along. After two-plus weeks of installation problems, this forum doing all it could to help me, I'd had enough and kept on GoDaddy for some answers. This after numerous reinstalls on my part and worthless responses to questions on theirs.

    Well, I've just successfully completed the installation after getting this message from GoDaddy support. Thought it might help someone else in a jam.

    "It appears as though your last installation of WordPress was either incomplete or corrupted and the install scripts never finished. However, due to the nature of our installation system, the install scripts were removed after the installation completed. I have uploaded the install scripts to your account and r-ran them. This appears to have fixed the issue with your current install. However, as a side effect your administrative user name is now '?????'. Your password should still be the same as what you have set. Due to the nature of this error we still recomend uninstalling and reinstalling WordPress. However, it is your prerogative, and you can keep this installation; as it should be working now.

    Because this is now a custom installation of WordPress; we can no longer provide technical support, for you current installation. For further assistance you will need to contact the software's developer.
    http://www.wordpress.org

  9. eternaldream
    Member
    Posted 1 month ago #

    So are you saying I should contact godaddy directly, to see if they can fix it on their end or something?

  10. chandlerwhite
    Member
    Posted 1 month ago #

    Well, make sure your wp-config.php file is good (you've had some good advice here). And if it doesn't work for you contact GoDaddy.

  11. eternaldream
    Member
    Posted 1 month ago #

    Well, I contacted Godaddy, and it seems they just sent me a cookie cutter response. It said where to go to find all the information to put in wp-config, which I already know. So, no new revelations yet.

  12. eternaldream
    Member
    Posted 1 month ago #

    I don't know what I did, but it works now! Thanks for the help!

Reply

You must log in to post.

About this Topic