MySql 8 数据库链接异常BUG和修改方法建议

TTTL

数据库环境：
centos7.5 docker mysql 8 及其以上JDBC链接方式需做以下修改

        /*
         * centos7.5 docker mysql 8 及其以上JDBC链接方式需做以下修改
         * 需更新链接方式解决Navicat 1251 错误后
         * 需更换驱动包 mysql-connector-java-8.0.11.jar 和数据库链接方式
         *
         * mysql Ver 8.0.12 for Linux on x86_64 (MySQL Community Server - GPL)
         * mysql-connector-java-8.0.11.jar
         */
        private static String driver = "com.mysql.cj.jdbc.Driver";
        private static String url = "jdbc:mysql://192.168.170.133:3306/plusoft_test?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=Asia/Shanghai";
        private static String user = "root";
        private static String pwd = "abcd123456";

felt

好的，我们这边用mysql版本比较低，高版本的链接方式需要改动，感谢反馈。

mfc

感谢楼主：
我在这里把mysql-connector-java-8.0.11.zip分享一下

mysql-connector-java-8.0

mysql.sql

1. /* show variables like "sql_mode"; */
   
2. 
   
3. set sql_mode='';
   
4. set sql_mode='NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES';
   
5. 
   
6. #
   
7. # Structure for the `plus_file` table :
   
8. #
   
9. 
   
10. CREATE TABLE `plus_file` (
    
11.   `id` VARCHAR(50) COLLATE utf8_general_ci NOT NULL DEFAULT '',
    
12.   `name` VARCHAR(500) COLLATE utf8_general_ci DEFAULT NULL,
    
13.   `type` VARCHAR(50) COLLATE utf8_general_ci DEFAULT NULL,
    
14.   `size` VARCHAR(20) COLLATE utf8_general_ci DEFAULT NULL,
    
15.   `url` VARCHAR(300) COLLATE utf8_general_ci DEFAULT NULL,
    
16.   `pid` VARCHAR(50) COLLATE utf8_general_ci DEFAULT NULL,
    
17.   `createdate` DATETIME DEFAULT NULL,
    
18.   `updatedate` DATETIME DEFAULT NULL,
    
19.   `folder` INTEGER(11) DEFAULT NULL,
    
20.   `num` INTEGER(11) DEFAULT NULL,
    
21.   PRIMARY KEY (`id`)
    
22. 
    
23. )ENGINE=InnoDB
    
24. CHARACTER SET 'utf8' COLLATE 'utf8_general_ci'
    
25. COMMENT='InnoDB free: 7168 kB; InnoDB free: 7168 kB';

复制代码

mysql-connector-java-8.0.11