mysql usessl false_连接hive时出现的（explicitlydisableSSLbysettinguseSSL=false）

[root@zhangkai conf]# hive

Logging initialized using configuration in

jar:file:/opt/hive-1.2.1/lib/hive-common-1.2.1.jar!/hive-log4j.properties

Sat Jul 20 10:36:43 CST 2019 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.

Sat Jul 20 10:36:44 CST 2019 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.

Sat Jul 20 10:36:44 CST 2019 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.

Sat Jul 20 10:36:44 CST 2019 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.

Sat Jul 20 10:36:45 CST 2019 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.

Sat Jul 20 10:36:45 CST 2019 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.

Sat Jul 20 10:36:45 CST 2019 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.

Sat Jul 20 10:36:45 CST 2019 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.

hive>

解决方法

连接hive时出现的这个问题，是在hive的conf配置文件中hive-site.xml加上就可以

javax.jdo.option.ConnectionURL

jdbc:mysql://192.168.8.111:3306/metastore?createDatabaseIfNotExist=true&useSSL=false

JDBC connect string for a

JDBC metastore