Installation problem: Can’t select database

  • Resolved 814714

    15 years, 8 months ago

    I have downloaded WAMP, installed the mysql, php & apache products.

    I am trying to connect to the DB in order to perform installation. I have edited the config file, but WP is unable to select the database. I know it exists, and the user has permission, so I guess that leaves the DB NAME? I’ve tried root_wordpress as the DB name, no luck.

    Would appreciate some help with this matter. I’ve installed WP a number of times, no problem. This is my first time locally however..

    ========================
    The 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 _wordpress database.

    * Are you sure it exists?
    * Does the user root@localhost 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?

    =================

Viewing 4 replies - 1 through 4 (of 4 total)
  • Moderator Samuel Wood (Otto)

    (@otto42)

    WordPress.org Admin

    15 years, 8 months ago

    What is the actual database name? Use that.

    Since it connected okay, then the dbhost, username, and password are correct. You simply have the database name wrong.

    “root_wordpress” makes little sense as a database name. Same for “_wordpress”. Did you perhaps just name it “wordpress”? You need *only* the database name, not any other stuff thrown in.

    Thread Starter 814714

    15 years, 8 months ago

    I have tried using the database name for DB name, the above error message was taken when I was experimenting with a variety of DB names, to see if it was a unknown convention causing issues.

    Jay Mayu

    (@mayooresan)

    15 years, 8 months ago

    try the user name “root” as I remember thatz the user name. and if you have not configrd ya MY SQL then there’ll be no password for ya DB. leave it empty.

    Thread Starter 814714

    15 years, 8 months ago

    try the user name “root” as I remember thatz the user name. and if you have not configrd ya MY SQL then there’ll be no password for ya DB. leave it empty.

    That did it! Thank you very much. In phpmyadmin it has root@localhost as the user, but using just root instead fixed it.

    Once again, thank you.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Installation problem: Can’t select database’ is closed to new replies.