Jira and MySQL with the coordination of building adjustment

Integration of Jira and MySQL data

The first step: install MySQL database on the computer, do not do much to explain, self-fix

Second step; Build a database named jiradb in MySQL database, account root password root code format utf-8

Step three: In the Jira default database (that is, the second path of the installation time, that is, where the data is saved), find a file named Dbconfig.xml file, will

<jira-database-config>
<name>defaultDS</name>
<delegator-name>default</delegator-name>
<database-type>hsql</database-type>
<schema-name>PUBLIC</schema-name>
<jdbc-datasource>
<url>jdbc:hsqldb:E:\jiraData/database/jiradb</url>
<driver-class>org.hsqldb.jdbcDriver</driver-class>
<username>sa</username>
<password></password>
<pool-size>20</pool-size>
<min-evictable-idle-time-millis>4000</min-evictable-idle-time-millis>
<time-between-eviction-runs-millis>5000</time-between-eviction-runs-millis>
</jdbc-datasource>
</jira-database-config>

This code is modified to

<jira-database-config>
<name>defaultDS</name>
<delegator-name>default</delegator-name>
<database-type>mysql</database-type>
<jdbc-datasource>
<url>jdbc:mysql://localhost:3306/jiradb?autoReconnect=true&amp;useUnicode=true&amp; Characterencoding=utf8</url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<username>root</username>
<password>root</password>
<pool-size>20</pool-size>
<min-evictable-idle-time-millis>4000</min-evictable-idle-time-millis>
<time-between-eviction-runs-millis>5000</time-between-eviction-runs-millis>
</jdbc-datasource>
</jira-database-config>

Restart the service to integrate with MySQL successfully

Transferred from: http://www.07net01.com/zhishi/380662.html

Note: MySQL Java connector is the driver file must correspond to the MySQL server version.

Jira and MySQL with the coordination of building adjustment