Database Connection Issues

The most common problems, that we have experienced is that clients who design there websites using a WAMP setup often forget to update the database details when uploading the files to our server.

Configuration Files : If you have transferred your domain from your local machine, always make sure that you update the CMS`s config files to use the new database details that we have setup for you. We have listed some examples of the config files below.

• Impress Pages (ip_config.php)

define('DB_SERVER', 'mysql.yourdomain.co.za'); // eg, localhost
define('DB_USERNAME', 'exampledb');
define('DB_PASSWORD', '***********');
define('DB_DATABASE', 'exampledb');
define('DB_PREF', 'ip_');

• Wordpress (wp-config.php)

/** The name of the database for WordPress */
define('DB_NAME', 'exampledb');
/** MySQL database username */
define('DB_USER', 'exampledb');
/** MySQL database password */
define('DB_PASSWORD', 'password_here');
/** MySQL hostname */
define('DB_HOST', 'mysql.yourdomain.co.za');

• Joomla (configuration.php)

 public $dbtype = 'mysqli';
 public $host = 'mysql.yourdomain.co.za';
 public $user = 'exampledb';
 public $password = '*********';
 public $db = 'exampledb';
 public $dbprefix = 'ijao8_';

• Opencart (config.php)

define('DB_DRIVER', 'mysql');
define('DB_HOSTNAME', 'mysql.yourdomain.co.za');
define('DB_USERNAME', 'exampledb');
define('DB_PASSWORD', '***********');
define('DB_DATABASE', 'exampledb');
define('DB_PREFIX', );