Submit a Ticket
Support Center » Knowledgebase » Popular CMS/E-commerce Connection String configuration (Windows)

Popular CMS/E-commerce Connection String configuration (Windows)

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" /> 



 This answer was helpful  This answer was not helpful
 Back