How to connect local installation to a remote database

**Owl01** · 2008-03-31, 03:06 PM

We have Sugar 5.0b on a Linux server linked up to a MySQL database on a separate server - both provided by a 3rd party webhost.

We have problems with the Sugar CRM server going down regularly for extended periods. Since the MySQL server is fine I have created a fresh install on my laptop of 5.0b and am trying to get it to point to our existing database.

The install has just created a new MySQL database locally, how do I get Sugar to point to the remote database? Do I need to reinstall? If so, do I need to install PHP locally or just the Sugar application?

**Angel** · 2008-03-31, 09:14 PM

Take a look at the root folder of your SugarCRM installation. You will find a file called config.php within that folder.

You will need to edit the following section:

Code:

  array (
    'db_host_name' => 'ADDRESS_FOR_REMOTE_MYSQL_SERVER',
    'db_host_instance' => '',
    'db_user_name' => 'MYSQL_LOGON_FOR_REMOTE_SERVER',
    'db_password' => 'MYSQL_PASSWORD_FOR_REMOTE_SERVER',
    'db_name' => 'SUGARDBNAME_ON_REMOTE_SERVER',
    'db_type' => 'mysql',
  )