Connection Configuration for MySQL
    • PDF

    Connection Configuration for MySQL

    • PDF

    Article summary

    summary

    This is the help page for setting up Connection Configuration for MySQL.

    entry

    item nameindispensableContents
    NameYesEnter the name of the Connection Configuration to be used inside TROCCO.
    memoNoEnter a note of Connection Configuration to be used inside TROCCO.
    hostYesEnter a host name or IP address.
    destination portYesEnter the port number of the database to connect to.
    The default port number for MySQL is 3306.
    userYesEnter a user name for authentication.
    (computer) passwordYesPlease enter your password for authentication.
    SSLYesSelect whether to use SSL (TLS) communication.
    Please refer to the case when SSL is enabled described below for the input items when enabled.
    Connecting via SSHNoSelect this option if you wish to connect via SSH (using SSH tunnel).
    For more information, please see Connecting via SSH Tunnel.
    Connecting via AWS Systems Manager Session ManagerNoFor more information, see Connecting with AWS Systems Manager Session Manager.
    JDBC DriverNoSelect the version of the JDBC driver that connects to the MySQL server.
    Depending on the version of MySQL you are using, you can choose from the following
  • 5.1.49
  • When using MySQL binlog (CDC), the selection in this item is ignored and the Series 8 JDBC driver is used.

    When SSL is enabled

    item nameindispensableContents
    CA certificateNoYou can enter a root certificate issued by a certification authority (CA). Please enter in pem file format.
    Certificate (CRT file)NoYou can enter a certificate for authentication to be used when the client accesses the server.
    Key (KEY file)NoYou can enter the private key corresponding to the client certificate. Please enter in pem file format.

    Was this article helpful?