Connection String Locations Reference

Connection string file location relative to the applications install directory, and the example connection information we will use is exampleuser, exampledbname, examplepassword, and localhost.

WordPress
File: /wp-config.php
Example:

define('DB_NAME', 'exampledbname');
define('DB_USER', 'exampleuser');
define('DB_PASSWORD', 'examplepassword');
define('DB_HOST', 'localhost');

Drupal
File: /sites/default/settings.php
Example:

$db_url = 'mysql://exampleuser:examplepassword@localhost/exampledbname';

Joomla
File: /configuration.php
Example:

public $host = 'localhost';
public $user = 'exampleuser';
public $password = 'examplepassword';
public $db = 'exampledbname';

OpenCart
File: /config.php
File: /admin/config.php
Example:

define('DB_HOSTNAME', 'localhost');
define('DB_USERNAME', 'exampleuser');
define('DB_PASSWORD', 'examplepassword);
define('DB_DATABASE', 'exampledbname);

Magento
File: /app/etc/local.xml
Example:

<host><![CDATA[localhost]]></host>
<username><![CDATA[exampleuser]]></username>
<password><![CDATA[examplepassword]]></password>
<dbname><![CDATA[exampledbname]]></dbname>

Concrete5
File: /application/config/database.php
Example:

'connections' => array(
      'concrete' => array(
            'driver' => 'c5_pdo_mysql',
            'server' => 'localhost',
            'database' => 'exampledbname',
            'username' => 'exampleuser',
            'password' => 'examplepassword',
            'charset' => 'utf8'
     )

Zen Cart
File: /includes/configure.php
File: /admin/includes/configure.php
Example:

define('DB_SERVER', 'localhost');
define('DB_SERVER_USERNAME', 'exampleuser');
define('DB_SERVER_PASSWORD', 'examplepassword');
define('DB_DATABASE', 'exampledbname');

phpBB
File: /config.php
Example:

$dbhost = 'localhost';
$dbname = 'exampledbname';
$dbuser = 'exampleuser';
$dbpasswd = 'examplepassword';

TYPO3
File: /typo3conf/LocalConfiguration.php
Example:

'DB' => [
      'Connections' => [
            'Default' => [
                  'charset' => 'utf8',
                  'dbname' => 'exampledbname',
                  'driver' => 'mysqli',
                  'host' => 'localhost',
                  'password' => 'examplepassword',
                  'port' => 3306,
                  'user' => 'exampleuser',
            ],
      ],
],

Moodle
File: /config.php
Example:

$CFG->dbhost = 'localhost'; // eg 'localhost' or 'db.isp.com' or IP
$CFG->dbname = 'exampledbname'; // database name, eg moodle
$CFG->dbuser = 'exampleuser'; // your database username
$CFG->dbpass = 'examplepassword'; // your database password
$CFG->prefix = 'exampletableprefix_'; // prefix to use for all table names

Comment to request additional applications be added.