Title: Help Selecting Database Problem
Last modified: August 18, 2016

---

# Help Selecting Database Problem

 *  [mikejones16](https://wordpress.org/support/users/mikejones16/)
 * (@mikejones16)
 * [19 years, 12 months ago](https://wordpress.org/support/topic/help-selecting-database-problem/)
 * 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](https://wordpress.org/support/users/miklb/)
 * (@miklb)
 * [19 years, 12 months ago](https://wordpress.org/support/topic/help-selecting-database-problem/#post-397421)
 * > 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](https://wordpress.org/support/users/mikejones16/)
 * (@mikejones16)
 * [19 years, 12 months ago](https://wordpress.org/support/topic/help-selecting-database-problem/#post-397423)
 * sorry that dosnt work either.
 *  [Michael Bishop](https://wordpress.org/support/users/miklb/)
 * (@miklb)
 * [19 years, 12 months ago](https://wordpress.org/support/topic/help-selecting-database-problem/#post-397425)
 * 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.

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)
 * [selecting](https://wordpress.org/support/topic-tag/selecting/)
 * [stuff](https://wordpress.org/support/topic-tag/stuff/)

 * In: [Installing WordPress](https://wordpress.org/support/forum/installation/)
 * 3 replies
 * 2 participants
 * Last reply from: [Michael Bishop](https://wordpress.org/support/users/miklb/)
 * Last activity: [19 years, 12 months ago](https://wordpress.org/support/topic/help-selecting-database-problem/#post-397425)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics