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...") |
|||
| (5 intermediate revisions by one other user not shown) | |||
| Line 1: | Line 1: | ||
| − | The most common | + | 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', ''); | ||
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', );