Difference between revisions of "Database Connection Issues"

From Imaginet FAQ
Jump to navigation Jump to search
 
(2 intermediate revisions by one other user not shown)
Line 1: Line 1:
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.
+
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. We have listed some examples of the config files below.
+
'''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)
 
* Impress Pages (ip_config.php)

Latest revision as of 16:27, 9 December 2021

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