Connect Service for Remote SQL DB on Port other than defaul 3306

Connecting to SQL
1

Hi There,

I am trying to configure a service for connecting to a remote MySQL database that is located somewhere in the internet.
I noticed that if I connect to a database server that is using the default port 3306 it works well. But if I configure for connecting to a server that is using a different port like 3310 it won’t work.

I have the following connection string:
mysql:host=****************.xxxxxxxxapp.net:3310;dbname=DFTest

I assume that the port 3306 is assumed by default so I specified 3310.

Any advice about this issue?

Thanks

2

Hey Willy.
The correct connection string for using a different port other than the default is
mysql:host=hostname;port=portnumber;dbname=databasename

3

Thanks a lot Drew.

I changed the connection string as you suggested and I have now a ClearDB database linked to DreamFactory.

Thanks a lot for your prompt answer.