• 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?

Viewing 11 replies - 1 through 11 (of 11 total)
  • 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

    Thread Starter eternaldream

    (@eternaldream)

    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?

    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');

    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

    Thread Starter eternaldream

    (@eternaldream)

    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.

    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?

    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.ww.wp.xz.cn

    Thread Starter eternaldream

    (@eternaldream)

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

    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.

    Thread Starter eternaldream

    (@eternaldream)

    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.

    Thread Starter eternaldream

    (@eternaldream)

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

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

The topic ‘Can’t select database error for GoDaddy hosting’ is closed to new replies.