jmeter连接数据库The driver has not received any packets from the server

╰半夏微凉° 2023-10-05 10:04 61阅读 0赞

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2h5azE0OTk0NDk4ODY_size_16_color_FFFFFF_t_70_pic_center]  
在用jemter连接数据库时报Cannot create PoolableConnectionFactory (Communications link failure  
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.)。翻阅各种资料，终于解决了。

**解决办法：将图中数据库URL改为jdbc:mysql://127.0.0.1（或者localhost）:3306/test即可  
因为root权限的数据库只能通过localhost访问，当然你也可以在虚拟机中用docker启动mysql，这样就可以用ip地址去访问啦，注意要把JDBC的jar包放到jmeter目录下的lib/ext里面。**

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2h5azE0OTk0NDk4ODY_size_16_color_FFFFFF_t_70_pic_center 1]

这样就完美解决啦  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2h5azE0OTk0NDk4ODY_size_16_color_FFFFFF_t_70_pic_center 2]

萌新第一次发博客，希望能帮助到大家，一起学习成长！！！

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2h5azE0OTk0NDk4ODY_size_16_color_FFFFFF_t_70_pic_center]: https://img-blog.csdnimg.cn/20200914213242920.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2h5azE0OTk0NDk4ODY=,size_16,color_FFFFFF,t_70#pic_center
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2h5azE0OTk0NDk4ODY_size_16_color_FFFFFF_t_70_pic_center 1]: https://img-blog.csdnimg.cn/20200914214308481.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2h5azE0OTk0NDk4ODY=,size_16,color_FFFFFF,t_70#pic_center
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2h5azE0OTk0NDk4ODY_size_16_color_FFFFFF_t_70_pic_center 2]: https://img-blog.csdnimg.cn/20200914214107415.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2h5azE0OTk0NDk4ODY=,size_16,color_FFFFFF,t_70#pic_center