环景:
windows server2019
crucible-4.8.2
jdk1.8
mysql5.7
mysql-connector-java-5.1.31-bin
问题描述:
crucible-4.8.2更改为mysql5.7数据库jdbc连接报错:
错误1:
Unable to connect to MySQL database jdbc:mysql://localhost:3306/crucible: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: User ‘crucible’ has exceeded the ‘max_questions’ resource (current value: 5) Couldn’t connect to the database
错误2:
解决错误1出现这个
解决方案:
错误1:Navicat 连接数据库,更改最大查询、连接数,默认0,我之前改动过,改回来
错误2:更改字符集为utf8mb4 ,utf8mb4_bin
完成
迁移数据库