pyspark在使用jdbc链接MySql时报错useSSL解决办法

pyspark

>>>jdbcDF = spark.read.format("jdbc").option("driver","com.mysql.jdbc.Driver").option("url","jdbc:mysql://localhost:3306/spark?useSSL=false").option("dbtable","student").option("user","root").option("password","anti.520").load()

报错信息：

Sat Oct 12 16:17:33 CST 2019 WARN: Establishing SSL connection without server‘s ide ntity 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 is n‘t set. For compliance with existing applications not using SSL the verifyServerCe rtificate 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 certific ate verification.

解决办法：

pyspark

>>> jdbcDF = spark.read.format("jdbc").option("driver","jdbc:mysql://localhost:3306/spark?useSSL=false").option("dbtable","anti.520").load()