• 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

    (@james1102)

    It’s saying that that database name isn’t found. So that name is wrong.

    Thread Starter james1102

    (@james1102)

    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

    (@macmanx)

    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.

    Hi, i’m having the same problem with my blog
    “Cana€?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 https://solcito.blogthing.com

    Moderator James Huff

    (@macmanx)

    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.

    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;

    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.