How to set useSSL=false in Mule 4 Database connector

Here are the steps to add useSSL=false in the Mule 4 Database connector. Ideally, MySQL database connection requires SSL to establish a connection. To overcome SSL warning from MySQL server we need to add useSSL=false; in JDBC URL. Similarly, we have an option in the Mule 4 Database connector configuration if you are using the SQL database connection.

Error:

Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.

Steps to add useSSL=false in My SQL Database Configuration of Mule 4

1. Click on Edit Database Configuration


2. Click on Advanced


3. Select Edit inline in Connection properties

4. Add the property as below and save

Mule 4 My SQL Database connection Properties:

<db:config name="Database_Config" >
  <db:my-sql-connection host="0.0.0.0" port="3306" user="root" password="password" database="dbname" >
    <db:connection-properties>
       <db:connection-property key="useSSL" value="false"/>
    </db:connection-properties>
  </db:my-sql-connection>
</db:config>

Also read: Mule 4 Beginner & Experienced tutorials | Introduction to Mule 4