Difference between revisions of "Database Connection Issues"
Jump to navigation
Jump to search
(Created page with "The most common problems, that we have experienced is that clients who design there websites on there local pc using a WAMP setup often forget to update the database details i...") |
|||
| Line 1: | Line 1: | ||
The most common problems, that we have experienced is that clients who design there websites on there local pc using a WAMP setup often forget to update the database details in the cms config files. | The most common problems, that we have experienced is that clients who design there websites on there local pc using a WAMP setup often forget to update the database details in the cms config files. | ||
| + | |||
| + | '''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. | ||
| + | |||
| + | * 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', ''); | ||
Revision as of 10:06, 2 November 2012
The most common problems, that we have experienced is that clients who design there websites on there local pc using a WAMP setup often forget to update the database details in the cms config files.
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.
- 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', );