Trying to set up SSL to MySQL database for DevTest

Document ID : KB000093533
Last Modified Date : 30/04/2018
Show Technical Document Details
Issue:
Trying to set up SSL to MySQL database, not seeing any doc on how to do this.

Error message indicates using useSSL=true variable but I don't see that in any CA config or MySQL config where do I set this?

2018-04-27 17:40:11,458Z (13:40) [C3P0PooledConnectionPoolManager[identityToken->2xx5bd9v29taol1b9no59|7a7d1b47]-HelperThread-#2] ERROR System.err - Fri Apr 27 13:40:11 EDT 2018 WARN: 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. 
Resolution:
Customer wanted to use SSL but did not care about sever authentication so they added the following to the connection string URL:

?verifyServerCertificate=false&useSSL=true

This resolved the issue.