Here we have collected the instructions for updating the links for database connections in products installed with our One Click Installer, if you change database and/or database server. The files are easily changed by retrieving via FTP, changing in optional text editor and uploading via FTP.

More information about FTP you can find here.

WordPress

When it comes to WordPress installation, these settings must be changed in the file called “wp-config.php“. If you download this file and open it in any text editor, you will see the lines to be used. The ones to change are following:

/** The name of the database for WordPress */
define ('DB_NAME', 'XXXXXXXXXXXXXX');
Here you insert your database name.

/** MySQL database password */
define ('DB_USER', 'XXXXXXXXXXXXXX');
Here you insert your database username.

/** MySQL database password */
define('DB_PASSWORD', 'XXXXXXXXXXXXXX');
Here you insert your database password.

/** MySQL hostname */
define('DB_HOST', 'XXXXXXXXXXXXXX');
Here you insert your database server address.

Joomla

If it is about Joomla installations, the setting thatneed to change are done in the file called “configuration.php“. If you download this file and open it in any text editor, you will see the lines that should be changed. What needs to change is the following:

public $host = 'XXXXXXXXXXXXXX';
Here you insert your database server address.

public $user = 'XXXXXXXXXXXXXX';
Here you insert your database username.

public $db = 'XXXXXXXXXXXXXX';
Here you insert your database name.

public $password = 'XXXXXXXXXXXXXX';
Here you insert your database password.

OpenCart

If you want to update the database link for OpenCart, two files must be edited. These files are “config.php” and “/admin_login/config.php“.

Download these files and edit them in any text editor and then reload them in their respective spaces.

In “/config.php“:

define('DB_HOSTNAME', 'XXXXXXXXXXXXXX');
Here you insert your database server address.

define('DB_USERNAME', 'XXXXXXXXXXXXXX');
Here you insert your database username.

define('DB_PASSWORD', 'XXXXXXXXXXXXXX');
Here you insert your database password.

define('DB_DATABASE', 'XXXXXXXXXXXXXX');
Here you insert the name of your database.

In the file “/admin_login/config.php“:

define('DB_HOSTNAME', 'XXXXXXXXXXXXXX');
Here you insert your database server address.

define('DB_USERNAME', 'XXXXXXXXXXXXXX');
Here you insert your database username.

define('DB_PASSWORD', 'XXXXXXXXXXXXXX');
Here you insert your database password.

define('DB_DATABASE', 'XXXXXXXXXXXXXX');
Here you insert the name of your database.

MediaWiki

To change the database link on a MediaWiki installation, edit the file “LocalSettings.php“.

Download this file in any text editor and edit the following lines:

$wgDBserver = "XXXXXXXXXXXXXX";
Here you insert your database server address.

$wgDBname = "XXXXXXXXXXXXXX";
Here you insert the name of your database.

$wgDBuser = "XXXXXXXXXXXXXX";
Here you insert your database username.

$wgDBpassword = "XXXXXXXXXXXXXX";
Here you insert your database password.