I am using an application that changes the connection to another database based on the login of the user. This works fine…as long as the database can be connected on port 3306 (standard for MySQL). But now I am using VPN and other security measures so the MySQL server has to be connected via another port. With SC_CONNECTION_EDIT() it is not possible to provide the different port.
NB: In the database connection screen I am able to specify a port different than 3306.
I am using mysqli to see if I can connect to the database and this works fine but how can I change the database connection for SC if I am not able to use the SC_CONNECTION_EDIT() macro?