mahout连接数据库MySQL8遇到Could not create connection to database server.

MySQL8.0版本需要更换驱动为“com.mysql.cj.jdbc.Driver”，之前的“com.mysql.jdbc.Driver”已经不能在MySQL 8.0版本使用了，官方文档链接：https://dev.mysql.com/doc/connector-j/8.0/en/connector-j-api-changes.html；

mysql-connector-java依赖更新为如下：

 

<dependency>
		<groupId>mysql</groupId>
		<artifactId>mysql-connector-java</artifactId>
		<version>8.0.11</version>
</dependency>

下面贴出mahout连接MySQL8的全部导入依赖

<dependency>
	    <groupId>org.apache.mahout</groupId>
	    <artifactId>mahout-core</artifactId>
	    <version>0.9</version>
	</dependency>
	
	 <!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<version>8.0.11</version>
		</dependency>
    
    <!-- https://mvnrepository.com/artifact/org.apache.mahout/mahout-examples -->
	<dependency>
	    <groupId>org.apache.mahout</groupId>
	    <artifactId>mahout-examples</artifactId>
	    <version>0.13.0</version>
	</dependency>
    
    <!-- https://mvnrepository.com/artifact/org.apache.mahout/mahout-examples -->
	<dependency>
	    <groupId>org.apache.mahout</groupId>
	    <artifactId>mahout-examples</artifactId>
	    <version>0.13.0</version>
	</dependency>
    
    		<dependency>
			<groupId>jdk.tools</groupId>
			<artifactId>jdk.tools</artifactId>
			<version>1.7</version>
			<scope>system</scope>
			<systemPath>${JAVA_HOME}/lib/tools.jar</systemPath>
		</dependency>
<!--这个地方不加入 jdk可能会报missingjdk:tools:1.7-->

更新依赖以后则又会出现

The server time zone value 'Öйú±ê׼ʱ¼ä' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support. 

这个鬼东西！这个出现的原因是因为时区问题

解决方法执行命令给MySQL服务器设置时区为东八区，这个是com.mysql.cj.jdbc.Driver需要指定的：

mysql> set global time_zone='+8:00';
Query OK, 0 rows affected