Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save themusicman/1118486 to your computer and use it in GitHub Desktop.
Save themusicman/1118486 to your computer and use it in GitHub Desktop.
EE2 Database Connection Information
//standard databases connection information
$db['expressionengine']['hostname'] = "localhost";
$db['expressionengine']['username'] = "db_username";
$db['expressionengine']['password'] = "db_password";
$db['expressionengine']['database'] = "db_name";
$db['expressionengine']['dbdriver'] = "mysql";
$db['expressionengine']['dbprefix'] = "exp_";
$db['expressionengine']['pconnect'] = FALSE;
$db['expressionengine']['swap_pre'] = "exp_";
$db['expressionengine']['db_debug'] = TRUE;
$db['expressionengine']['cache_on'] = FALSE;
$db['expressionengine']['autoinit'] = FALSE;
$db['expressionengine']['char_set'] = "utf8";
$db['expressionengine']['dbcollat'] = "utf8_general_ci";
$db['expressionengine']['cachedir'] = "/expressionengine/cache/db_cache/";
//notice the array index of secondary, we will use this later...
$db['secondary']['hostname'] = "localhost";
$db['secondary']['username'] = "db_username";
$db['secondary']['password'] = "db_password";
$db['secondary']['database'] = "db_name";
$db['secondary']['dbdriver'] = "mysql";
$db['secondary']['dbprefix'] = ""; // <---- Make sure this is empty or set to another prefix if you are using one
$db['secondary']['pconnect'] = FALSE;
$db['secondary']['swap_pre'] = ""; // <---- Make sure this is empty or set to another prefix if you are using one
$db['secondary']['db_debug'] = TRUE;
$db['secondary']['cache_on'] = FALSE;
$db['secondary']['autoinit'] = FALSE;
$db['secondary']['char_set'] = "utf8";
$db['secondary']['dbcollat'] = "utf8_general_ci";
$db['secondary']['cachedir'] = "/expressionengine/cache/db_cache/";
@azazqadir
Copy link

azazqadir commented May 20, 2020

Does expressionengine supports MariaDB? I was trying to install it on my hosting (this one: https://www.cloudways.com/en/expressionengine-hosting.php ) They support MariaDB 10+ versions. After installing, when i try to connect the DB i am getting some SQL error

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment