With Beekeeper studio, create a new connection, select MySQL as the connection type and fill out the following details (Figure C): Host: The IP address or domain of your MySQL server. Port: 3306.

The MySQL workbench executes the required SQL statement under the covers, and the schema is listed in the tool. With the schema created, you can now provide any JDBC drivers, Hibernate config or JPA ...

Select the mysql-connector-java-XXX-bin.jar file (where XXX is the release number) and click OK. Click OK to exit out of the Options window and you’re ready to connect to your remote database ...