After a recent update of mySql, I get this warning:<\/p>\n
WARN: Establishing SSL connection without server's identity verification is not recommended. \r\nAccording to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established \r\nby default if explicit option isn't set. For compliance with existing applications not using SSL \r\nthe verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL \r\nby setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.\r\n<\/pre>\nTo disable disable SSL and also suppress the SSL warning, it’s possible to set to false the useSSL parameter on the connection string:<\/p>\n
jdbc:mysql:\/\/localhost:3306\/myDb?autoReconnect=true&useSSL=false<\/pre>\nOn applicationContext, something like this:<\/p>\n
<!-- \u00a0############ MY SQL DATABASE SECTION ############ --><\/div>\r\n<bean id=\"dataSource\" class=\"org.springframework.jdbc.datasource.DriverManagerDataSource\"><\/div>\r\n\u00a0 \u00a0 <property name=\"driverClassName\"><value>com.mysql.jdbc.Driver<\/value><\/property><\/div>\r\n\u00a0 \u00a0 <property name=\"url\"><\/div>\r\n\u00a0 \u00a0 \u00a0 \u00a0 <value>jdbc:mysql:\/\/${mysql.hostname}:${mysql.port}\/${mysql.db}?useSSL=false<\/value><\/div>\r\n\u00a0 \u00a0 <\/property><\/div>\r\n\u00a0 \u00a0 <property name=\"username\"><value>${mysql.user}<\/value><\/property><\/div>\r\n\u00a0 \u00a0 <property name=\"password\"><value>${mysql.password}<\/value><\/property><\/div>\r\n<\/bean><\/div>\r\n<\/pre>\nShare this:<\/h3>