[关闭]
@nextleaf 2018-05-24T21:29:45.000000Z 字数 1022 阅读 3372

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

  7. 回到“编辑驱动设置”

  8. 类名改为com.mysql.jdbc.Driver
  9. 点击“连接属性”,
  10. 空白处右键添加新属性
    名:zeroDateTimeBehavior    值:CONVERT_TO_NULL
  11. 确定
  12. 测试链
添加新批注
在作者公开此批注前,只有你和作者可见。
回复批注