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

野性酷女 2023-09-26 09:47 8阅读 0赞

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

如图：

![1d33db3670c84b078e8dbe8e3d47f4b5.png][]

> 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)![favicon.ico][]https://downloads.mysql.com/archives/c-j/][MySQL _ Download MySQL Connector_J _Archived Versions_favicon.ico_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添加进去即可。

![fd6f84a3701d45c388614f45bc284997.png][]

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

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

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

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

[1d33db3670c84b078e8dbe8e3d47f4b5.png]: https://img-blog.csdnimg.cn/1d33db3670c84b078e8dbe8e3d47f4b5.png
[favicon.ico]: https://labs.mysql.com/common/themes/sakila/favicon.ico
[MySQL _ Download MySQL Connector_J _Archived Versions_favicon.ico_https_downloads.mysql.com_archives_c-j]: https://downloads.mysql.com/archives/c-j/
[fd6f84a3701d45c388614f45bc284997.png]: https://img-blog.csdnimg.cn/fd6f84a3701d45c388614f45bc284997.png