WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] Can't select database (9 posts)

  1. milesb1
    Member
    Posted 2 years ago #

    I cannot access my wordpress admin log in page and the link to my site comes up with the same message:

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

    Are you sure it exists?
    Does the user wrdR0OrNF6n have permission to use the wrd_bnei3d3adg database?
    On some systems the name of your database is prefixed with your username, so it would be like username_wrd_bnei3d3adg. Could that be the problem?

    Internal Server Error

    The server encountered an internal error or misconfiguration and was unable to complete your request.

    Please contact the server administrator, cgiadmin@yourhostingaccount.com and inform them of the time the error occurred, and anything you might have done that may have caused the error.

    More information about this error may be available in the server error log.

    Can anyone please help me in finding the solution to this problem?

  2. esmi
    Forum Moderator
    Posted 2 years ago #

    Confirm your database details with your hosts.

  3. milesb1
    Member
    Posted 2 years ago #

    I've contacted my hosting company asking for the details but it's still not working.

  4. esmi
    Forum Moderator
    Posted 2 years ago #

    I;m sorry but there's nothing we can really add to help you from here.

  5. patrickdickey
    Member
    Posted 2 years ago #

    I have essentially the same error on my installation. I'm able to access the database in mysql on the server (I'm hosting the site in a virtual machine on the computer that I'm trying to run the installation script from).

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

    Are you sure it exists?
    Does the user root have permission to use the wordpress database?
    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?
    If you don't know how to set up a database you should contact your host. If all else fails you may find help at the WordPress Support Forums.

    in mysql>, use wordpress; gives me database changed. show tables; gives me 0 records (empty set).

    One thing to note is that I'm using the root user for mysql to access it. Could that be the issue (that wordrpess/apache/mysql somehow blocks this)?

    Thanks and have a great day:)
    Patrick.

  6. DaveCoast
    Member
    Posted 2 years ago #

    Did you create a database and user as per step 2 in the instructions - WordPress Instructions

    WordPress needs its very own database specific user created for the connection.

    Please create and/or verify that your user (for WordPress) has been added to your WordPress database.

  7. esmi
    Forum Moderator
    Posted 2 years ago #

    @patrickdickey: It is impolite and contrary to forum policy to interrupt another poster's ongoing thread with a question of your own. Please post your own topic.

  8. milesb1
    Member
    Posted 2 years ago #

    The problem is resolved now. Thanks to everyone for their support.

    The problem was that I hadn't input the necessary data in the correct location.

  9. patrickdickey
    Member
    Posted 2 years ago #

    Sorry for interrupting. I threw mine in because it was almost the exact same situation as the original posters. My mistake, and it won't happen again. Like the original poster, my issue is solved now as well.

    Have a great day:)
    Patrick.

Topic Closed

This topic has been closed to new replies.

About this Topic