How to update database connection strings

The information in this article is related to konsoleH.
If you are using our new Control Panel, refer to this article.

Make the switch and discover a simpler, more secure way to manage your hosting.

Use the konsoleH File Manager (recommended) or FTP program such as FileZilla or CuteFTP  to retrieve the configuration file and edit your database configuration.

This is required when setting up a new database or when the database password has been updated. Using Option 1 (File Manager) is recommended as it makes edits directly on the server without the need to download, edit and then upload the configuration file via FTP.

Option1: Edit connection strings via File Manager:

  1. Browse to konsoleH and login
  2. Click Manage Services from the left-hand menu
  3. Select Files & Folders > File Manager
  4. Within File Manager select the configuration file and select Edit from the right hand menu
  5. Manage MySQL
    • For Wordpress please edit wp-config.php
    • For Joomla please edit configuration.php
    • For Drupal please edit sites/default/settings.php
    • For Magento please edit app/etc/local.xml
  6. Search for the information you wish to change and replace by clicking and replacing the text, where:
    • DB_NAME is the database name
    • DB_USER is the database login
    • DB_PASSWORD is the database password
    • DB_HOST is the database server name (note that the database does not live on the same server as the website)
  7. Click Save Changes

Option2: Edit connection strings via FTP program:

  1. Make an FTP connection to your domain with your FTP program..
  2. Locate the public_html directory. (In most programs you will be able to ‘double click’ to access this folder).
  3. Locate the applicable configuration file for your database eg. configuration.php.
    • For Wordpress please edit wp-config.php
    • For Joomla please edit configuration.php
    • For Drupal please edit sites/default/settings.php
    • For Magento please edit app/etc/local.xml
  4. Download this file to your local computer.
  5. Open the file in Notepad or a text editor of your choice and search for the information (hostname, database name, username/login, and password) you wish to change.
  6. Replace all instances of the old information with the new details e.g. old passwords with new passwords.
  7. Save your changes.
  8. Upload the updated configuration file with your FTP program to replace the current one.

Should you be familiar with Telnet or SSH you may wish to access and edit the configuration files directly on the hosting server.

Related Posts: