Skip to:
Content
Pages
Categories
Search
Top
Bottom

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


  • TristanOBAv
    Member

    @tristanobav

    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:

    http://bbpress.org/forums/topic/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:

    <?php

    /**

    * 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 https://api.wordpress.org/secret-key/1.1/bbpress/ WordPress.org 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 de.mo 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.

    Tristan

You must be logged in to reply to this topic.