DBeaver报错：can't load driver class 'com.mysql.cj.jdbc.Driver'

如图：

Can't create driver instance
  Error creating driver 'Mysql' instance.
Most likely required jar files are missing.
You should configure jars in driver settings.

Reason: can't load driver class 'com.mysql.cj.jdbc.Driver'
  Error creating driver 'Mysql' instance.
Most likely required jar files are missing.
You should configure jars in driver settings.

Reason: can't load driver class 'com.mysql.cj.jdbc.Driver'
    com.mysql.cj.jdbc.Driver
    com.mysql.cj.jdbc.Driver

原因是缺少对应的连接器，下载：

MySQL :: Download MySQL Connector/J (ArcHived Versions)https://downloads.mysql.com/archives/c-j/选择Platform Independent (Architecture Independent), ZIP Archive。

下载解压后，找到里面的mysql-connector-java-8.0.29.jar文件，然后，

数据库 - 驱动器管理 

选择 MySql - 编辑 - 库 - 添加文件，

把mysql-connector-java-8.0.29.jar添加进去即可。

一种在mmysql版本8+登录进去修改用户密码的方式：

mysql> SET PASSWord FOR 'root'@'localhost' = '123456';

123456是新密码，对root用户修改。这种修改密码的方式比较适合mysql密码字符串

中包含有特殊字符比如 $&之类。 

来源地址：https://blog.csdn.net/zhangphil/article/details/127143124