• Resolved sandg

    (@sandg)


    I’ve created a db called ‘wordpress’ in HELM and my hoster tells me that I’m able to use WP on their server. I set up config file and uploaded but get this error.

    site here

    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 pslwp have permission to use the wordpess 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 setup a database you should contact your host. If all else fails you may find help at the WordPress Support Forums.

    // ** MySQL settings ** //
    define('DB_NAME', 'wordpress');    // The name of the database
    define('DB_USER', 'pslwp');     // 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', '');

    Would appreciate any help I can get. Thanks in advance!

Viewing 2 replies - 1 through 2 (of 2 total)
  • MichaelH

    (@michaelh)

    1. the database is wrong
    2. the database user is wrong
    3. the database user doesn’t have privileges for that database.

    If you can’t solve it, confirm with your host that you are using the correct information.

    had the same problem and finally figured out that when accessing mysql5 via my particular host i also had to include the socket name.

    so while this didn’t work for ‘DB_HOST’:
    localhost

    this did:
    localhost:/tmp/mysql5.sock

    hope this helps other users. the message that the db connection is working, but can’t find the database (when it clearly exists) is confusing!

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

The topic ‘Can’t select database’ is closed to new replies.