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密码字符串
中包含有特殊字符比如 $&之类。
版权归原作者 zhangphil 所有, 如有侵权,请联系我们删除。