13

Databases

Last Update 3 anni fa

How To Update Database Connection Strings How To Convert From MS-Access To MySQL What Does Database Administration Involve? How To Secure Your Database MySQL Indexes For Database Optimization

How To Update Database Connection Strings

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

Leeann Morgan

Last Update 3 anni fa

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.

Was this article helpful?

0 out of 0 liked this article

Still need help? Message Us