Categories

Checking CMS/E-commerce database&configuration details

Phil Nowak July 19, 2011
Rating: 5.0/5. From 3 votes.
Please wait...

Sometimes you may need to find out your database details or change it. The best way to do it is to view configuration file in your system. Each CMS/e-commerce engine has a different filename and path to save this data. In this tutorial you will learn the way to edit/locate your CMS/e-commerce configuration files and configuration data.

WordPress

Open your WordPress installation root and locate following file: wp-config.php

You will be able to see a lot of scripting, the one you need is:

define('DB_NAME', '****');
//Database name definition

define('DB_USER', '****');
//Database user name definition

define('DB_PASSWORD', '****');
//Database password

define('DB_HOST', 'localhost');
//Database host, usually localhost.

$table_prefix  = 'wp_';

Database Prefix, “wp_” is the default one.

Joomla

Open your Joomla installation root and locate following file: configuration.php

You will be able to see some scripting, the one you need is:

var $dbtype = 'mysql';
//Database type

var $host = 'localhost';
//Database host, usually localhost

var $user = '****';
//Database user name definition

var $password = '****';
//Database password

var $db = '****';
//Database name definition

var $dbprefix = 'jos_';

Database Prefix, “jos_” is the default one.

Drupal 6

Open your Drupal installation root and locate following file: sites/default/settings.php

You will be able to see some scripting, the one you need is:

$db_url = 'mysqli://root@localhost/drupal6'; 

//Database name, URL, login and password. It may look different, the structure is as it follows:

$db_url = 'mysql://username:xxx/databasename';

$db_prefix = '';
//Database Prefix

Drupal 7

You need to edit same file as for Drupal 6 but the structure is different: sites/default/settings.php

You will be able to see some scripting, the one you need is:

'database' => '****',
//Database name
	  
'username' => '****',
//Database username
	  
'password' => '****',
//Database password
	  
'host' => 'localhost',
//Database URL
	  
'port' => '',
//You can enter database server port here if needed

'driver' => 'mysql',
//Your database type
	  
'prefix' => '',
//Database Prefix

PrestaShop

Open your PrestaShop installation root and locate following file: /config/settings.inc.php

You will be able to see the following data:

define('__PS_BASE_URI__', '/link/prestashop/');
//Your Prestashop installation folder, your website folder

define('_THEME_NAME_', 'theme068');
//Your theme name

define('_DB_NAME_', '****');
//Your database name

define('_DB_SERVER_', 'localhost');
//Your database URL, regularly it is localhost

define('_DB_USER_', '****');
//Your database user name

define('_DB_PREFIX_', 'ps_');
//Your database prefix

define('_DB_PASSWD_', '****');
//Database password

define('_DB_TYPE_', 'MySQL');
//Database type

define('_COOKIE_KEY_', 'oKxpLkDzaQ8HPcWJz4PnoeA27CEV7b6A33M4gdXfFWNwurb3kcHPh6xM');
//This key is generated automatically

define('_COOKIE_IV_', 'kTq5big3');
//This key is provided automatically

define('_PS_VERSION_', '1.3.2.3');
//Your Prestashop version

Magento

Open your Magento installation root and locate following file: app/etc/local.xml

You will be able to see some scripting, the one you need is:


//Your database URL, regularly it is localhost


//Your database user name


//Database password


//Your database name

osCommerce

Open your osCommerce installation root and locate following file: includes/configure.php

You will be able to see a lot of scripting, the one you need is:

define('DB_SERVER', 'localhost');
//Your database URL, usually it is localhost

define('DB_SERVER_USERNAME', '****');
//Your database user name

define('DB_SERVER_PASSWORD', '****');
//Database password

define('DB_DATABASE', '****');
//Your database name

define('STORE_SESSIONS', 'mysql');
//Your database type

Zen-Cart

Open your Zen-Cart installation root and locate following files (Zen-Cart has 2 configuration files, you need to edit both files): adminfolder/includes/configure.php and includes/configure.php

You will be able to see a lot of scripting, the one you need is:

define('DB_TYPE', 'mysql');
//Your database type

define('DB_PREFIX', '');
//Database prefix

define('DB_CHARSET', 'utf8');
//Database character set

define('DB_SERVER', 'localhost');
//Your database URL, regularly it is localhost

define('DB_SERVER_USERNAME', '****');
//Your database user name

define('DB_SERVER_PASSWORD', '****');
//Database password

define('DB_DATABASE', '****');
//Your database name

OpenCart

Open your Opencart installation root and locate following file: config.php

You will be able to see a lot of scripting, the one you need is:


define('DB_DRIVER', 'mysql');
//Your database type

define('DB_HOSTNAME', 'localhost');
//Your database URL, regularly it is localhost

define('DB_USERNAME', '****');
//Your database user name

define('DB_PASSWORD', '****');
//Database password

define('DB_DATABASE', '****');
//Your database name

define('DB_PREFIX', '');
//Database prefix

Virtuemart

Since VirtueMart is Joomla component, configuration file is absolutely the same as in Joomla CMS. Please check the details above.

 

This entry was posted in Hosting FAQ and tagged CMS, database, ecommerce. Bookmark the permalink.

Submit a ticket

If you are still unable to find a sufficient tutorial regarding your issue please use the following link to submit a request to our technical support team. We'll provide you with our help and assistance within next 24 hours: Submit a ticket