Wordpress config - live / local / staging database configs in the one file.

gistfile1.txt

/** Database Charset to use in creating database tables. */
define('DB_CHARSET', 'utf8');
 
/** The Database Collate type. Don't change this if in doubt. */
define('DB_COLLATE', '');
 
// ** MySQL settings - You can get this info from your web host ** //
switch ($_SERVER['SERVER_NAME']) {
	case 'mysite.localhost':
		define('DB_NAME', 'local_database_name');
	define('DB_USER', 'JP');
		define('DB_PASSWORD', 'XXXXXXXXXXX');
		define('DB_HOST', 'localhost');
		define('WP_DEBUG', false);
		break;
	case 'mysite.stagingdomain.com.au':
		define('DB_NAME', 'staging_database_name');
		define('DB_USER', 'staging_databse_user');
		define('DB_PASSWORD', 'XXXXXXXXXXX');
		define('DB_HOST', 'localhost');
		define('WP_DEBUG', false);
		break;
	default:
		define('DB_NAME', 'live_database_name');
		define('DB_USER', 'live_database_user');
		define('DB_PASSWORD', 'XXXXXXXXXXX');
		define('DB_HOST', 'localhost');
		define('WP_DEBUG', false);
 
}

// Then, remember to delete the define('WP_DEBUG', false); that exists further down in the wp-config file