Help Selecting Database Problem

  • mikejones16

    (@mikejones16)


    17 years, 10 months ago

    Ok… This is how my wp-config.php file looks like

    ————-
    // ** MySQL settings ** //
    define(‘DB_NAME’, ‘iotera_wordpress’); // The name of the database
    define(‘DB_USER’, ‘iotera_wpiotera’); // Your MySQL username
    define(‘DB_PASSWORD’, ‘Bleeped’); // …and password
    define(‘DB_HOST’, ‘localhost’); // 99% chance you won’t need to change this value
    ————-

    Ok, in CPanel, i created a database called ‘wordpress’ .. And it renamed itself to ‘iotera_wordpress’.
    I added a user, user ‘wpiotera’. And it renamed itself to ‘iotera_wpiotera’.
    Ok so i entered that information into my config.php file and i am STILL getting an error saying “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 wpiotera_wordpress database.

    * Are you sure it exists?
    * On some systems the name of your database is prefixed with your username, so it would be like username_wordpress. Could that be the problem?
    “
    —
    Thank you SO MUCH if you can help me!

Viewing 3 replies - 1 through 3 (of 3 total)
  • Michael Bishop

    (@miklb)

    17 years, 10 months ago

    but not able to select the wpiotera_wordpress database.

    define(‘DB_NAME’, ‘iotera_wordpress‘); // The name of the database

    I think if you resolve the names, all will work.

    Thread Starter mikejones16

    (@mikejones16)

    17 years, 10 months ago

    sorry that dosnt work either.

    Michael Bishop

    (@miklb)

    17 years, 10 months ago

    what doesn’t work?

    WP is looking for a database called wpiotera_wordpress, you said your config file has iotera_wordpress.

    something isn’t jiving. You need to backtrack and make sure that all of your info matches.

    In the event that they do, then the issue of where the database is can come into play (some hosts, the 1%, are not localhost).

    But until the config info and what WP is looking for match up, I’d ignore the later.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Help Selecting Database Problem’ is closed to new replies.