Title: Cant select database
Last modified: August 18, 2016

---

# Cant select database

 *  [james1102](https://wordpress.org/support/users/james1102/)
 * (@james1102)
 * [20 years, 11 months ago](https://wordpress.org/support/topic/cant-select-database-2/)
 * I am getting the following error:
 * 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 bodybuilderinfo_com_-
   _wordpress database.
 * The name of the database set up is exactly as above?? Why cant the database be
   selected??? Thanks

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

 *  Thread Starter [james1102](https://wordpress.org/support/users/james1102/)
 * (@james1102)
 * [20 years, 11 months ago](https://wordpress.org/support/topic/cant-select-database-2/#post-214662)
 *  [oriecat](https://wordpress.org/support/users/oriecat/)
 * (@oriecat)
 * [20 years, 11 months ago](https://wordpress.org/support/topic/cant-select-database-2/#post-214663)
 * It’s saying that that database name isn’t found. So that name is wrong.
 *  Thread Starter [james1102](https://wordpress.org/support/users/james1102/)
 * (@james1102)
 * [20 years, 11 months ago](https://wordpress.org/support/topic/cant-select-database-2/#post-214830)
 * Well the name is exactly as it was (cut and pasted) and created. That is the 
   problem. It seems obvious but for some reason no matter how many times i change
   the name or create another database it isnt working
 *  Moderator [James Huff](https://wordpress.org/support/users/macmanx/)
 * (@macmanx)
 * [20 years, 11 months ago](https://wordpress.org/support/topic/cant-select-database-2/#post-214848)
 * Perhaps you have the wrong database server. If you’re 100% sure that “bodybuilderinfo_com_-
   _wordpress” is correct, then the only possibility left is that “bodybuilderinfo_com_-
   _wordpress” does not exact at the database server that you have selected.
 *  [solcito](https://wordpress.org/support/users/solcito/)
 * (@solcito)
 * [20 years, 11 months ago](https://wordpress.org/support/topic/cant-select-database-2/#post-215008)
 * Hi, i’m having the same problem with my blog
    “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 wordpress13a5 database.
 * what is happening?
    the url is [http://solcito.blogthing.com](http://solcito.blogthing.com)
 *  Moderator [James Huff](https://wordpress.org/support/users/macmanx/)
 * (@macmanx)
 * [20 years, 11 months ago](https://wordpress.org/support/topic/cant-select-database-2/#post-215009)
 * 1. Have you read this thread?
 * 2. Have you confirmed that the database name is correct?
 * 3. Have you confirmed that database host is correct?
 * 4. Have you confirmed that database user is correct?
 * 5. Have you confirmed that database user password is correct?
 * One or more of those five will be a “no” answer. You must fix it.
 *  [kekawaka](https://wordpress.org/support/users/kekawaka/)
 * (@kekawaka)
 * [20 years, 11 months ago](https://wordpress.org/support/topic/cant-select-database-2/#post-215017)
 * Just went through this myself, and had a few frustrating moments. The database
   name was correct, the host was correct, the user was correct, the password was
   correct. In the end, I found that the new table I had created wasn’t accessible
   to the user. Open a terminal session to your server and try this (substituting
   your wordpress variables for wp_user/wp_password/wp_database):
 * `mysql -u wp_user -p
    wp_password
 * mysql> use wp_database;
 * I suspect that will fail. So exit mysql, and relogin as root. Then:
 * `grant all privileges on *.* to 'wp_user'@'localhost'
    identified by 'PASSWORD';
 * mysql> flush privileges;
 *  [jessmina](https://wordpress.org/support/users/jessmina/)
 * (@jessmina)
 * [20 years, 9 months ago](https://wordpress.org/support/topic/cant-select-database-2/#post-215214)
 * I’m having exactly the same problem, and made a recent post about it. However,
   I don’t understand the instructions given in the last post (I’m not very technically-
   minded). So if anybody can break these steps down further for a MySQL/server 
   newbie, that’d be fantastic.

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

The topic ‘Cant select database’ is closed to new replies.

## Tags

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

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 8 replies
 * 6 participants
 * Last reply from: [jessmina](https://wordpress.org/support/users/jessmina/)
 * Last activity: [20 years, 9 months ago](https://wordpress.org/support/topic/cant-select-database-2/#post-215214)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics