In order to edit your connection string, please follow the steps below:
1. Login to the SolidCP panel.
2. Choose File Manager from under the Hosting Space Menu tab.
3. Click on the domain you have installed the application on and choose wwwroot.
- your_database > is your MySQL Database Name
- your_username > is your MySQL User Name
- your_password > is your MySQL password
- your_hostname > is your MySQL Host Name
PS: For your specific Database Hostname (your_hostname), you can check your Space Summary under your Hosting Space by following this TUTORIAL
WordPress Connection String:
The connection string for WordPress is described in the wp-config.php located in the 'wwwroot' folder under your domain.
Below is a sample of the code you need to edit in order to change the connection string:
/** The name of the database for WordPress */
define('DB_NAME', 'your_database');
/** MySQL database username */
define('DB_USER', 'your_username');
/** MySQL database password */
define('DB_PASSWORD', 'your_password');
/** MySQL hostname */
define('DB_HOST', 'your_hostname');
Joomla Connection String:
The connection string for Joomla is described in the configuration.php located in the 'wwwroot' folder under your domain.
Below is a sample of the code you need to edit in order to change the connection string:
public $host = 'your_hostname';
// This is the DB host
public $user = 'your_username';
// DB username
public $password = 'your_password';
// DB password
public $db = 'your_database';
// DB database name
Drupal Connection String:
The connection string for Joomla is described in the settings.php located in the 'wwwroot/sites/default/' folder under your domain.
Below is a sample of the code you need to edit in order to change the connection string:
$databases['default']['default'] = array(
'driver' => 'mysql',
'database' => 'your_database',
'username' => 'your_username',
'password' => 'your_password',
'host' => 'your_hostname',
);
Magento Connection String:
The connection string for Magento is described in the local.xml located in the 'wwwroot/app/etc/' folder under your domain.
Below is a sample of the code you need to edit in order to change the connection string:
<config>
<global>
<install>
<date><![CDATA[Tue, 30 Apr 2013 13:42:46 +0000]]></date>
</install>
<crypt>
<key><![CDATA[f71bejhefa9510f00422fc8650f46c24]]></key>
</crypt>
<disable_local_modules>false</disable_local_modules>
<resources>
<db>
<table_prefix><![CDATA[]]></table_prefix>
</db>
<default_setup>
<connection>
<host><![CDATA[your_hostname]]></host>
<username><![CDATA[your_username]]></username>
<password><![CDATA[your_password]]></password>
<dbname><![CDATA[your_database]]></dbname>
<initStatements><![CDATA[SET NAMES utf8]]></initStatements>
<model><![CDATA[mysql4]]></model>
<type><![CDATA[pdo_mysql]]></type>
<pdoType><![CDATA[]]></pdoType>
<active>1</active>
</connection>
</default_setup>
</resources>
<session_save><![CDATA[files]]></session_save>
</global>
<admin>
<routers>
<adminhtml>
<args>
<frontName><![CDATA[admin]]></frontName>
</args>
</adminhtml>
</routers>
</admin>
</config>
PrestaShop Connection String:
The connection string for PrestaShop is described in the settings.inc.php located in the 'wwwroot//config/' folder under your domain.
Below is a sample of the code you need to edit in order to change the connection string:
<?php
define('_DB_SERVER_', 'your_hostname');
define('_DB_NAME_', 'your_database');
define('_DB_USER_', 'your_username');
define('_DB_PASSWD_', 'your_password');
define('_DB_PREFIX_', 'ps_');
define('_MYSQL_ENGINE_', 'InnoDB');
define('_PS_CACHING_SYSTEM_', 'CacheApc');
define('_PS_CACHE_ENABLED_', '0');
define('_COOKIE_KEY_', 'VydXpBBvqfdVyGyVY44qVfFTvL23AG1szj0Avsd271PtuNw5CbORvvOIs');
define('_COOKIE_IV_', 'PIx53ASw');
define('_PS_CREATION_DATE_', '2017-05-07');
define('_PS_VERSION_', '1.6.1.14');
define('_RIJNDAEL_KEY_', '4H8PRpv43fsdDSuZXUx9iLiiwRb2af5');
define('_RIJNDAEL_IV_', '8Xav8t+xvdft54D+k/KI1g==');
define('_PS_DIRECTORY_', '/../../');
DNN and other ASP.NET based applications Connection String:
The connectionString node in web.config is where asp.net retrieves connection strings from. DotNetNuke ships with the files for installation on sql server, and by default a connection string of SiteSqlServer is used to determine what connection string to use.
The default web.config setting is to use sql server express and looks similar to this:
<add name="SiteSqlServer" connectionString="Server=(your_hostname);
Database=your_database;
uid=your_username;
pwd=your_password;
"providerName="System.Data.SqlClient" />
