Protocol used by JDBC to connect to MySQL on different Host

mysql database networking jdbc windows-firewall
Ajinkya Mahagaonkar picture Ajinkya Mahagaonkar · Aug 8, 2014 · Viewed 10.2k times · Source

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.

Answer

vhu picture vhu · Aug 8, 2014

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

Related questions

'IF' in 'SELECT' statement - choose output value based on column values

SELECT id, amount FROM report I need amount to be amount if report.type='P' and -amount if report.type='N'. How do I add this to the above query?

Read More
How do I quickly rename a MySQL database (change schema name)?

The MySQL manual at MySQL covers this. Usually I just dump the database and reimport it with a new name. This is not an option for very big databases. Apparently RENAME {DATABASE | SCHEMA} db_name TO new_db_name; does …

Read More
MySQL Error: : 'Access denied for user 'root'@'localhost'

$ ./mysqladmin -u root -p 'redacted' Enter password: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: YES)' How can I fix this?

Read More