Connect to Aiven for MySQL® with Java
=====================================

This example connects your Java application to an Aiven for MySQL® service.

Variables
'''''''''

These are the placeholders you need to replace in the code sample:

.. list-table::
   :widths: 20 80
   :header-rows: 1

   * - Variable
     - Description
   * - ``MYSQL_HOST``
     - Host name for the connection, from `Aiven Console <https://console.aiven.io/>`__ > the **Overview** page of your service > the **Connection information** section
   * - ``MYSQL_PORT``
     - Port number to use, from `Aiven Console <https://console.aiven.io/>`__ > the **Overview** page of your service > the **Connection information** section
   * - ``MYSQL_PASSWORD``
     - Password for ``avnadmin`` user
   * - ``MYSQL_DATABASE``
     - Database to connect

Pre-requisites
''''''''''''''

* JDK 1.8+

* MySQL JDBC Driver, which could be downloaded in the following ways:

  * Manually from `MySQL Community Downloads <https://dev.mysql.com/downloads/connector/j/>`_
  * Or using maven

    .. code-block:: bash

       mvn org.apache.maven.plugins:maven-dependency-plugin:2.8:get -Dartifact=mysql:mysql-connector-java:8.0.28:jar -Ddest=mysql-driver-8.0.28.jar

Code
''''

Add the following to ``MySqlExample.java``:

.. literalinclude:: /code/products/mysql/connect.java
   :language: java

This code creates a MySQL client and connects to the database. It fetches version of MySQL and prints it the output.

Run the code after replacement of the placeholders with values for your project:

.. code::

   javac MySqlExample.java && java -cp mysql-driver-8.0.28.jar:. MySqlExample -host MYSQL_HOST -port MYSQL_PORT -database MYSQL_DATABASE -username avnadmin -password MYSQL_PASSWORD

If the script runs successfully, the output will be the values that were inserted into the table:

.. code::

   Version: 8.0.26

Now that your application is connected, you are all set to use Java with Aiven for MySQL.