Ubuntu下Dbeaver community 连接mysql8
标签（空格分隔）： mysql 数据库 数据库管理工具
前置：ubutu 18.04,openjdk 10.0.1，mysql8
- 下载安装Dbeaver community
- 启动Dbeaver community
- （新连接）选择mysql，下一步
- 填写mysql8的用户名和密码
- 点击“编辑驱动设置”
- 点击“下载/更新”，点击版本号选择版本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
- 回到“编辑驱动设置”
- 类名改为com.mysql.jdbc.Driver
- 点击“连接属性”，
- 空白处右键添加新属性
名：zeroDateTimeBehavior 值：CONVERT_TO_NULL - 确定
- 测试链
