Database Connection Issues

From Imaginet FAQ
Jump to navigation Jump to search

The most common problem that we have experienced is that clients who design their 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.

Example Configs 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', );