PhpStorm MySQL Connector/J更新至5.1.40后停止工作 [英] PhpStorm MySQL Connector/J stopped working after update to 5.1.40

问题描述

在PhpStorm建议更新MySQL驱动程序之后，我与MySQL数据库的现有连接和有效连接已停止工作.我在Ubuntu和另一台Mac上都看到了这个问题.我收到的错误是:

After PhpStorm suggested to update MySQL driver, my existing and working connections to MySQL databases had stopped working. I saw this problem reproduced on my Ubuntu and on another Mac. The error I received was:

[08S01]通信链接失败.

[08S01] Communications link failure.

我使用SSH隧道访问数据库.此外，我使用的是PhpStorm的最新稳定版本(2017.1.2).引起问题的驱动程序版本是5.1.40和5.1.41，我在尝试解决此问题时手动安装了它们.

I use SSH tunneling to access the databases. Also, I use the latest stable version of PhpStorm (2017.1.2). The driver versions that caused troubles were 5.1.40 and 5.1.41 which I installed manually while trying to fix the problem.

是否有解决此问题的快速方法?我真的需要继续工作.

Is there a quick way to fix that? I really need to continue working.

推荐答案

最新版本的MySQL Connector/J似乎存在一些问题.解决方案是回滚以在PhpStorm中使用以前版本的MySQL Connector/J驱动程序.就我而言，以前的版本是5.1.35，可以正常工作.

It seems that the latest versions of MySQL Connector/J have some issues. The solution is to rollback to use the previous version of MySQL Connector/J driver in PhpStorm. In my case, the previous version was 5.1.35, which is working fine.

问题在于回滚不是那么明显.在驱动程序选择弹出窗口中没有先前的版本:

The problem is that the rollback is not that obvious. I didn't have the previous version in a driver selection popup:

解决方案是添加我的PC上已经存在的其他驱动程序文件:

The solution was to add an additional driver file that already existed on my PC:

添加驱动程序后，最后一步是禁用使用提供的驱动程序"复选框:

Once I added the driver, the last step was to disable the "Use provided driver" checkbox:

然后我应用了更改，并且连接再次起作用.

Then I applied the changes, and the connections worked again.

希望这会有所帮助.

这篇关于PhpStorm MySQL Connector/J更新至5.1.40后停止工作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！