Move MySQL to a separate server

Management and Administration
#1

I would like to set up a distributed environment using Ubuntu and the LAMP stack, where the OEMR application server is on one LAMP installation and the MySQL database is on a separate LAMP server. Is this possible and how would I configure OEMR to point to the remote MySQL instance?

#2

Database connection parameters in sites directory.

#3

@Ken_Quigley

Please refer the below steps:

  1. Grant the required permissions to the server(containing the database) and the mysql, so that the server which contains the openemr can access.
  2. Change the crendetials at openemr/sites/default/sql_conf.php with appropriate details.
  3. Check whether the ports are open.
    Also refer the link given.
    https://www.cloudways.com/blog/connect-to-remote-mysql-database/.

Let us know for further clarifications.

Thanks,
ViSolve