Spark中用DataFrame从本地电脑mysql8.0为数据源加载数据时，报错如下：

Exception in thread "main" java.lang.ClassNotFoundException: org.mysql.cj.jdbc.Driver

       at java.net.URLClassLoader.findClass(URLClassLoader.java:381)

       at java.lang.ClassLoader.loadClass(ClassLoader.java:424)

       at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:335)

       at java.lang.ClassLoader.loadClass(ClassLoader.java:357)

       at org.apache.spark.sql.execution.datasources.jdbc.DriverRegistry$.register(DriverRegistry.scala:46)

       at org.apache.spark.sql.execution.datasources.jdbc.JDBCOptions.$anonfun$driverClass$1(JDBCOptions.scala:101)

       at org.apache.spark.sql.execution.datasources.jdbc.JDBCOptions.$anonfun$driverClass$1$adapted(JDBCOptions.scala:101)

       at scala.Option.foreach(Option.scala:407)

       at org.apache.spark.sql.execution.datasources.jdbc.JDBCOptions.<init>(JDBCOptions.scala:101)

       at org.apache.spark.sql.execution.datasources.jdbc.JDBCOptions.<init>(JDBCOptions.scala:39)

       at org.apache.spark.sql.execution.datasources.jdbc.JdbcRelationProvider.createRelation(JdbcRelationProvider.scala:33)

       at org.apache.spark.sql.execution.datasources.DataSource.resolveRelation(DataSource.scala:350)

       at org.apache.spark.sql.DataFrameReader.loadV1Source(DataFrameReader.scala:274)

       at org.apache.spark.sql.DataFrameReader.$anonfun$load$3(DataFrameReader.scala:245)

       at scala.Option.getOrElse(Option.scala:189)

       at org.apache.spark.sql.DataFrameReader.load(DataFrameReader.scala:245)

       at org.apache.spark.sql.DataFrameReader.load(DataFrameReader.scala:174)

       at com.mm.sql.Demo02$.createFromJdbc(Demo02.scala:221)

       at com.mm.sql.Demo02$.main(Demo02.scala:29)

       at com.mm.sql.Demo02.main(Demo02.scala)

23/05/24 16:25:33 INFO SparkContext: Invoking stop() from shutdown hook

23/05/24 16:25:33 INFO SparkUI: Stopped Spark web UI at http://LG:4107

23/05/24 16:25:33 INFO MapOutputTrackerMasterEndpoint: MapOutputTrackerMasterEndpoint stopped!

23/05/24 16:25:33 INFO MemoryStore: MemoryStore cleared

23/05/24 16:25:33 INFO BlockManager: BlockManager stopped

解决办法：到Maven Repository: mysql » mysql-connector-java » 8.0.25 (mvnrepository.com)找到如下内容，复制到Idea的pom.xml中

<!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>8.0.25</version>
</dependency>