Protocol used by JDBC to connect to MySQL on different Host

Question

I want to know what is the protocol that is used by JDBC to connect to MySQL Database that is present on an other host.

My client has only http and https access restricted to his host. I want an application on an other host to communicate with that MySQL Database available on my client's host.

Please note my Client uses WINDOWS 2012 SERVER

He has asked me the protocols and ports my application is using to connect to MySQL so that he would enable them.

Request you to help.

Solution 1

By default mysql server uses 3306/tcp port but this is configurable. They should open up only the port that the server is listening on. Regarding the protocol it is mysql specific, you can find more info at the official documentation

Solution 2

By default MySQL server listens on port 3306/TCP. See manual for more details.

Solution 3

MySQL uses its own binary protocol over TCP to destination port 3306 to connect to the database. If you cannot get a path open betwee your client and the server for port 3306 maybe you can get the server configured to use a port that IS available to you. It would depend on who has the stricter rules, the network admins or the DBA :-)