jmeter连接不上MySQL数据库的原因以及解决方法

1.Cannot create PoolableConnectionFactory (Client does not support authentication protocol requested by server; consider upgrading MySQL client)

原因:jar包比数据库版本低,楼主用的数据库是MySQL 8.0.12,而jdbc是mysql-connector-java-5.1.7-bin.jar

解决方法:删除现有的jar包,重新导入新的jar包(楼主下的是对应于MySQL 8.0.12的jar包:mysql-connector-java-8.0.12.jar)

下面是MySQL jdbc(即jar包)驱动的下载链接:

下载链接(官网):https://dev.mysql.com/downloads/connector/j/

下载链接(包含各个版本的mysql jdbc的驱动):http://central.maven.org/maven2/mysql/mysql-connector-java/

下载链接:https://mvnrepository.com/artifact/mysql/mysql-connector-java

2.  Cannot create PoolableConnectionFactory (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的url后添加:?serverTimezone=UTC

  

补充说明:UTC(格林威治时间坐标)

3.jmeter链接MySQL的方法

   https://www.cnblogs.com/syw20170419/p/9832402.html

一行代码一行诗
原文地址:https://www.cnblogs.com/huainanhai/p/11311549.html