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:
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||ZY{.(`-?wBu>NTOdV’);
define(‘BB_LOGGED_IN_KEY’, ‘;+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.