How to change ispconfig DB to remote mysql server?

Discussion in 'Installation/Configuration' started by skysky, Oct 17, 2020.

  1. skysky

    skysky Member

    Hi

    I want to change ispconfig DB from current local to remote mysql server, in order to test, I first change the db setting in below config file to a wrong db setting to see if it breaks the ispconfig. so strange that it does not break it and I can still click around without any error. so strange

    ISPConfig 3 Interface
    Location of the config file is:
    /usr/local/ispconfig/interface/lib/config.inc.php


    ISPConfig 3 Server
    Location of the config file is:
    /usr/local/ispconfig/server/lib/config.inc.php

    MySQL root password used to create new databases is stored:
    /usr/local/ispconfig/server/lib/mysql_clientdb.conf
    for this config setting, it's not pointing to any DB, what is this for?
    $clientdb_host = 'localhost';
    $clientdb_user = 'root';
    $clientdb_password = 'root';
     
  2. ahrasis

    ahrasis Well-Known Member

    I did this test long time ago on new servers but never did try it on active servers. Generally it's the same as you install in an expert mode for slave ISPConfig server, where I think after dumping all database to the new server, you may need to add the remote users credentials to it so that they can access the database properly.
     
    Jesse Norell likes this.

Share This Page