Ubuntu下Dbeaver community 连接mysql8

标签(空格分隔): mysql 数据库 数据库管理工具


前置:ubutu 18.04,openjdk 10.0.1,mysql8

  1. 下载安装Dbeaver community
  2. 启动Dbeaver community
  3. (新连接)选择mysql,下一步
  4. 填写mysql8的用户名和密码
  5. 点击“编辑驱动设置”
  6. 点击“下载/更新”,点击版本号选择版本8.0.11点击下载
    报错:

java
The connection property ‘zeroDateTimeBehavior’ acceptable values are: ‘CONVERT_TO_NULL’, ‘EXCEPTION’ or ‘ROUND’. The value ‘convertToNull’ is not acceptable.
The connection property ‘zeroDateTimeBehavior’ acceptable values are: ‘CONVERT_TO_NULL’, ‘EXCEPTION’ or ‘ROUND’. The value ‘convertToNull’ is not acceptable.
The connection property ‘zeroDateTimeBehavior’ acceptable values are: ‘CONVERT_TO_NULL’, ‘EXCEPTION’ or ‘ROUND’. The value ‘convertToNull’ is not acceptable.
The connection property ‘zeroDateTimeBehavior’ acceptable values are: ‘CONVERT_TO_NULL’, ‘EXCEPTION’ or ‘ROUND’. The value ‘convertToNull’ is not acceptable.
No enum constant com.mysql.cj.conf.PropertyDefinitions.ZeroDatetimeBehavior.CONVERTTONULL
No enum constant com.mysql.cj.conf.PropertyDefinitions.ZeroDatetimeBehavior.CONVERTTONULL

  1. 回到“编辑驱动设置”
  2. 类名改为com.mysql.jdbc.Driver
  3. 点击“连接属性”,
  4. 空白处右键添加新属性
    名:zeroDateTimeBehavior    值:CONVERT_TO_NULL
  5. 确定
  6. 测试链

文章来源于互联网:2018-05-24Ubuntu 18.04桌面版下使用Dbeaver community 连接mysql8

发表评论