Support » Installing WordPress » [error]Can’t select database (with picture)

  • Hello,
    I have a problem with the installation of WP>
    Strange because the last tme I tried to install WP on the same host it didn’t gave me problems. But now my host is gone I tried to make a new one, but it gave me errors.

    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 himnews?himnews database.

    Are you sure it exists?
    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 setup a database you should contact your host. If all else fails you may find help at the WordPress Support Forums.”

    I made a picture so I can clear it up.
    http://xs216.xs.to/xs216/07236/wordpress_HIMN.jpg

    What can I do? I tried a lot, I worked on it for days and I did it a long time ago, but now it doesn’t work.

    define(‘DB_NAME’, ‘himn’); // The name of the database
    define(‘DB_USER’, ‘himn’); // Your MySQL username
    define(‘DB_PASSWORD’, ‘*****’); // …and password
    define(‘DB_HOST’, ‘localhost’); // 99% chance you won’t need to change this value
    define(‘DB_CHARSET’, ‘utf8’);
    define(‘DB_COLLATE’, ”);

    Thanks in advance!

Viewing 4 replies - 1 through 4 (of 4 total)
  • I hope in the original config file you have ‘himn_something’ because that’s the name of the DB and of the user.

    Yes, the bold indicates that you have grouped some databases with the himn_ prefix

    So you have data bases named
    himn_himnsomethingelse
    himn__wordpress

    the himn twice in the first line is deliberate and matches what you’ve shown.

    In short, actualy select the db and phpmyadmin will refresh and show the REAL full name for the database above the list of tables in that left sidebar. Use what it says there.

    Thread Starter harker

    (@harker)

    It worked, thanks!

    BTW I was wrong. I setup a database with this structure the other day. Your databases were named:
    himn????
    himn????_wordpress

    I’d not configured it that way before, but now I know.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘[error]Can’t select database (with picture)’ is closed to new replies.