Skip to:

Mix of 'DB Error: cannot select' and 'ERROR: Could not establish a database con'

  • Hi,

    I’m having trouble connecting to my database that I have set up. Firstly it looks like the first step of the install process is changing the forum database (causing the DB Error: cannot select’, as in this forum post:

    DB Error: cannot select

    I went ahead and changed the config file manually, but when this happens I get the ‘ERROR: Could not establish a database connection’.

    I have a feeling it is to do with leaving the MYSQL hostname as localhost. If so, where should I get the alternate hostname?

    Here is the config file:



    * The base configurations of bbPress.


    * This file has the following configurations: MySQL settings, Table Prefix,

    * Secret Keys and bbPress Language. You can get the MySQL settings from your

    * web host.


    * This file is used by the installer during installation.


    * @package bbPress


    // ** MySQL settings – You can get this info from your web host ** //

    /** The name of the database for bbPress */

    define( ‘BBDB_NAME’, ‘Forum’ );

    /** MySQL database username */

    define( ‘BBDB_USER’, ‘XXXXXXXXXXXXXX’ );

    /** MySQL database password */

    define( ‘BBDB_PASSWORD’, ‘XXXXXXXXXX’ );

    /** MySQL hostname */

    define( ‘BBDB_HOST’, ‘localhost’ );

    /** Database Charset to use in creating database tables. */

    define( ‘BBDB_CHARSET’, ‘utf8’ );

    /** The Database Collate type. Don’t change this if in doubt. */

    define( ‘BBDB_COLLATE’, ” );


    * Authentication Unique Keys.


    * Change these to different unique phrases!

    * You can generate these using the {@link secret-key service}


    * @since 1.0


    define(‘BB_AUTH_KEY’, ‘Y]YVAAW{KX<z8*H4,E`8t2%j#F{yFuz?6yZDR-|}Ot@m <P8|TKIpyaF]Mh_N*RO’);

    define(‘BB_SECURE_AUTH_KEY’, ‘lgS<S0vo^-ojBRp(_i6@9uUa<e|36aXV)_B|8#Eqb^M|=O|ZY{.(`-?wBu>NTOdV’);

    define(‘BB_LOGGED_IN_KEY’, ‘;:P+XoB4ti%4.!RhNcuE3|n_1~Va,oQ6>1%b9O>^A ;:{^XXzCi=G`f))q9 B{!u’);

    define(‘BB_NONCE_KEY’, ‘d44;tp-T)%z:p;fz}P{4PzGrdp8DfIt$g@O?}-)bqn_lE|@;L^sEIO75zC-(I#J@’);



    * bbPress Database Table prefix.


    * You can have multiple installations in one database if you give each a unique

    * prefix. Only numbers, letters, and underscores please!


    $bb_table_prefix = ‘bb_’;


    * bbPress Localized Language, defaults to English.


    * Change this to localize bbPress. A corresponding MO file for the chosen

    * language must be installed to a directory called “my-languages” in the root

    * directory of bbPress. For example, install to “my-languages” and set

    * BB_LANG to ‘de’ to enable German language support.


    define( ‘BB_LANG’, ” );


    Any help would be greatly appreciated, thanks in advance.


  • You must be logged in to reply to this topic.
Skip to toolbar