Database connection strings for most common scripts

A database connection string is composed of four parameters. You need a hostname/server, a database name, a database user, and a database password for the user. We will list below some of the most common scripts and where to find their database connection strings.

mariadb logo
MariaDB Logo


WordPress keeps the connection information in the file wp-config.php . The file is located at the root of the installation.

// ** MySQL settings - You can get this info from your web host ** //
/** The name of the database for WordPress */
define( 'DB_NAME', 'database_name_here' );

/** MySQL database username */
define( 'DB_USER', 'username_here' );

/** MySQL database password */
define( 'DB_PASSWORD', 'password_here' );

/** MySQL hostname */
define( 'DB_HOST', 'localhost' );


The path to the file containing the database string is /system/config.php

// Database Configuration
define('DB_DRIVER', 'amysqli');
define('DB_HOSTNAME', 'localhost');
define('DB_USERNAME', 'database_username');
define('DB_PASSWORD', 'database_password');
define('DB_DATABASE', 'database_name');
define('DB_PREFIX', 'prefix_');


The location of the config file is /config/

define('_DB_SERVER_', 'localhost');
define('_DB_NAME_', 'database_name');
define('_DB_USER_', 'database_user');
define('_DB_PASSWD_', 'database_password');
define('_DB_PREFIX_', 'pswb_');
define('_MYSQL_ENGINE_', 'InnoDB');


The file with the database string is presented at the root of the installation. The file name is configuration.php

	public $dbtype = 'mysqli';
	public $host = 'localhost';
	public $user = 'database_username';
	public $password = 'database_password';
	public $db = 'database_name';
	public $dbprefix = 'prefix_';


The configuration file for database connection is /sites/default/settings.php

$databases['default']['default'] = array (
  'database' => 'database_name',
  'username' => 'database_username',
  'password' => 'database_password',
  'prefix' => 'prefix_',
  'host' => 'localhost',
  'port' => '3306',
  'namespace' => 'Drupal\\Core\\Database\\Driver\\mysql',
  'driver' => 'mysql',


The configuration file containing the string is located in the root of the installation – config.php

$CFG->dbtype    = 'mysqli';
$CFG->dblibrary = 'native';
$CFG->dbhost    = 'localhost';
$CFG->dbname    = 'database_name';
$CFG->dbuser    = 'database_username';
$CFG->dbpass    = 'database_password';
$CFG->prefix    = 'prefix_';
$CFG->dboptions = array (
  'dbpersist' => 0,
  'dbport' => '',
  'dbsocket' => '',
  'dbcollation' => 'utf8_general_ci',

Leave a Reply