Database error for existing site

  • Resolved courtneycj

    (@courtneycj)


    14 years, 9 months ago

    Hello,
    I just got done upgrading my site to the latest version of php. Whereas I couldn’t log in to my dashboard at all before, I’m now getting the following error 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 [mydatabase] database.

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

    I inserted all of the information as I had done so before on my old site and exactly as it’s listed in 1&1. I don’t think this is a problem with the host. Can anyone offer me any advice as to how to fix this? Thank you very much!

Viewing 3 replies - 1 through 3 (of 3 total)
  • Sugar Apple

    (@blacklizt)

    14 years, 9 months ago

    take a look at

    On some systems the name of your database is prefixed with your username, so it would be like username_[mydatabase].

    for example, you are using Cpanel webhosting with username courtneycj and you make a database name wordpress

    so, you need to edit your wp-config.php
    define('DB_NAME', 'courtneycj_wordpress');

    i hope it works, my host like this

    Thread Starter courtneycj

    (@courtneycj)

    14 years, 9 months ago

    I fixed the problem — the username was actually the problem, but I fixed it. Thanks for your suggestion!

    Sugar Apple

    (@blacklizt)

    14 years, 9 months ago

    you’re welcome

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

The topic ‘Database error for existing site’ is closed to new replies.