Navicat(在用)

Navicat Premium Lite (免费)

DataGrip

DBeaver(免费、小)

问题

1、DBeaver 显示系统数据库不全

DBeaver显示系统数据库不全_dbeaver数据库显示不全_水木小窝的博客-CSDN博客

2、DBeaver 连接 mysql 时 Public Key Retrieval is not allowed 错误解决

  1. 在新建连接的时候,驱动属性里设置 allowPublicKeyRetrieval 的值为 true。

    DBeaver连接mysql时Public Key Retrieval is not allowed错误解决附图片_dbeavor public key retrieval is not allowed 解决-CSDN博客

  2. 编辑链接

    For DBeaver users:

    Right-click your connection, choose "Edit Connection"

    On the "Connection settings" screen (main screen), click on "Edit Driver Settings"

    Click on "Driver properties"

    Set these two properties: "allowPublicKeyRetrieval" to true and "useSSL" to false 在新建连接的时候,驱动属性里设置 allowPublicKeyRetrieval 的值为 true。

    Connection Java - MySQL : Public Key Retrieval is not allowed