Connected to database server but not database

  • terrian

    (@terrian)


    9 years, 10 months ago

    Hi there,

    I am using my Mac to host this database. I got this error message;

    “We were able to connect to the database server (which means your username and password is okay) but not able to select the ‘theresa’ database.

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

    I have have already configured “theresa” database to grant all privileges to “root” (my username) without password.

    I did not name the database “root_theresa” on my phpmyadmin, should I change the username in my wp-config.php from root to “root_theresa”?

    I am lost here on what should the next step be. Please help. Thank you.

    Theresa

Viewing 2 replies - 1 through 2 (of 2 total)
  • Moderator t-p

    (@t-p)

    9 years, 10 months ago

    – double check your wp-config.php file settings for the database name, database username and database password, and the host name (e.g., “localhost” Vs. something else). This is where most errors occur.
    – Then make sure wp-config.php is in right location.
    – Then check that you don’t need to change the database host from “localhost” to something else. You can get that info from your hosting provider.
    – Check you have actually created a database with the same database name as is in your wp-config.php file.
    – Last, but not least, if all that information is correct your database probably has a problem with it, and you may need to contact your hosting provider if the database server is online / if they have any other problem at their end, or they made any changes to your account,

    bikermanirl

    (@bikermanirl)

    9 years, 9 months ago

    You are connecting to the database fine so you need to check that your user has been added to the database with sufficient permissions.

    If the user is root, it should be able to access it.

    Check your wp-config file for any whitespace in the variables e,g “root ” instead of “root” thats is usually the problem.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Connected to database server but not database’ is closed to new replies.

Tags