spark SQL连接本地MYSQL的代码及一些问题

代码：
val spark: SparkSession = SparkSession.builder().master("local[*]").appName("SparkSQL")     .config("spark.sql.warehouse.dir","file:///D://sparkTest").getOrCreate()
    //必须配置config("spark.sql.warehouse.dir","file:///D://sparkTest")
val sc: SparkContext = spark.sparkContext
val sqlContext = new SQLContext(sc)
val jdbcDF = sqlContext.read.format("jdbc").options(Map("url"->"jdbc:mysql://192.168.43.49:3306/world?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC","driver"->"com.mysql.cj.jdbc.Driver","dbtable"->"city","user"->"root","password"->"******")).load()
    jdbcDF.show(5)

问题一

Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
The last packet successfully received from the server was 319 milliseconds ago.  The last packet sent successfully to the server was 319 milliseconds ago.

问题二

Caused by: com.mysql.cj.exceptions.InvalidConnectionAttributeException: 
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 Server的bin目录下，命令行输入mysql -hlocalhost -uroot -p
C:\Program Files\MySQL\MySQL Server 5.7\bin>mysql -hlocalhost -uroot -p
Enter password: ********
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 19
Server version: 5.7.30-log MySQL Community Server (GPL)
Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
//mysql设置wait_timeout
mysql> set global WAIT_TIMEOUT=1814400;
Query OK, 0 rows affected (0.00 sec)
mysql> show global variables like 'wait_timeout';
+---------------+---------+
| Variable_name | Value   |
+---------------+---------+
| wait_timeout  | 1814400 |
+---------------+---------+
1 row in set, 1 warning (0.00 sec)

问题二解决方法

serverTimezone=UTC//一定要有