首页 > 数据库技术 > 详细

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

时间:2019-10-12 21:27:39      阅读:324      评论:0      收藏:0      [点我收藏+]

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", "com.mysql.jdbc.Driver").option("url", "jdbc:mysql://localhost:3306/spark?useSSL=false").option("dbtable", "student").option("user", "root").option("password","anti.520").load()

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

原文:https://www.cnblogs.com/cepaAllium/p/11663902.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!