• When I go to install, I get this:

    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 <database name> database.

    I’ve checked all settings and they are fine. Need help figuring out what’s next!

    Thanks!

Viewing 5 replies - 1 through 5 (of 5 total)
  • No, they are not fine – if you got that message. (99.99% of cases it is the user’s fault, despite stating “it is fine” 🙂

    Did you add the user to the db? Is the DB name correct? (it’s case sensitive) Did you put it in the right place?

    Thread Starter fallsman

    (@fallsman)

    Fortunately, I’m not a total noobe. I’ve checked to ensure all is right (text pasted below). I’ve tried with the username_db and that didn’t work (different error).

    I like your 99.99% line, and it’s probably true, but a quick search turned up umpteen of these same errors, many of them having to do with GoDaddy (what I use). Surely someone could easily figure this out by now.

    Thanks for the help, but I need help beyond telling me to check all the stuff the error message tells me to check.

    Further thoughts? I’m not trying to be sarcastic, I really do appreciate the help.

    Thread Starter fallsman

    (@fallsman)

    My bad … here’s my text (changed my username and password out for those words):

    <?php
    // ** MySQL settings ** //
    define(‘DB_NAME’, ‘prville’); // prville
    define(‘DB_USER’, ‘username’); // username
    define(‘DB_PASSWORD’, ‘password’); // password
    define(‘DB_HOST’, ‘mysql111.secureserver.net’); // 99% chance you won’t need to change this value

    // You can have multiple installations in one database if you give each a unique prefix
    $table_prefix = ‘wp_’; // Only numbers, letters, and underscores please!

    // Change this to localize WordPress. A corresponding MO file for the
    // chosen language must be installed to wp-includes/languages.
    // For example, install de.mo to wp-includes/languages and set WPLANG to ‘de’
    // to enable German language support.
    define (‘WPLANG’, ”);

    /* That’s all, stop editing! Happy blogging. */

    define(‘ABSPATH’, dirname(__FILE__).’/’);
    require_once(ABSPATH.’wp-settings.php’);
    ?>

    If it’s godaddy… then you should continue to search 🙂 As you may have found already there are challenges installing on that host, but I remember threads where users posted back what they did to succeed.

    Are you on Win or Linux package?

    Here’s what I figured out for myself:

    “DB Manager is installed with a default database that uses the same name as your domain name (with underbars replacing periods).”

    Now I went ahead and created an additional database: my_domain_wordpress, and I got the error as cited in this thread.

    When I retreated to just using the default database “my_domain” created by DB Manager it worked fine. Moreover, once I put stuff in the default db, then I could get wordpress to work in the 2nd db just fine.

    So, you can’t create use secondary db if the default one is empty? I don’t know, but perhaps this will be useful for the next guy.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Can’t Select Database …’ is closed to new replies.