windows下JIRA7.2.0和MySql5.7数据库连接Unknown system variable ‘storage

    技术2022-07-11  82

    在上图的安装路径下添加dbconfig.xml 内容如下,需自行修改用户名密码

    <?xml version="1.0" encoding="UTF-8"?> <jira-database-config> <name>defaultDS</name> <delegator-name>default</delegator-name> <database-type>mysql</database-type> <jdbc-datasource> <url>jdbc:mysql://127.0.0.1:3306/jira?useUnicode=true&characterEncoding=UTF8&</url> <driver-class>com.mysql.jdbc.Driver</driver-class> <username>用户名</username> <password>密码</password> <pool-min-size>20</pool-min-size> <pool-max-size>20</pool-max-size> <pool-max-wait>30000</pool-max-wait> <validation-query>select 1</validation-query> <min-evictable-idle-time-millis>60000</min-evictable-idle-time-millis> <time-between-eviction-runs-millis>300000</time-between-eviction-runs-millis> <pool-max-idle>20</pool-max-idle> <pool-remove-abandoned>true</pool-remove-abandoned> <pool-remove-abandoned-timeout>300</pool-remove-abandoned-timeout> <pool-test-on-borrow>false</pool-test-on-borrow> <pool-test-while-idle>true</pool-test-while-idle> <validation-query-timeout>3</validation-query-timeout> </jdbc-datasource> </jira-database-config>

    如果xml文件中有 sessionVariables=storage_engine=InnoDB,请删除掉。 重启jira。

    Processed: 0.015, SQL: 9