Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-63725

Amendment required to doco on Connecting JIRA applications to MySQL

XMLWordPrintable

      The Atlassian article "Connecting JIRA applications to MySQL" needs to be amended so that it instructs the administrator to grant the 'REFERENCES' privilege to the JIRA user.

      The current instructions are as follows:

      "GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER,INDEX on <JIRADB>.* TO '<USERNAME>'@'<JIRA_SERVER_HOSTNAME>' IDENTIFIED BY '<PASSWORD>';

      With the release of JIRA 7.3, MySQL 5.7 is now a supported platform, for which our current instructions do not work.

      Omitting the REFERENCES privilege can create problems for plugins that set up foreign-key relationships between entities. It causes exceptions to be thrown, the below when trying to create a new project in a fresh installation of JIRA 7.3.0 with MySQL 5.7:

      com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: REFERENCES command denied to user 'JIRAUSER'@'HOST' for table 'AO_5FB9D7_AOHIP_CHAT_LINK'

          Form Name

            [JRASERVER-63725] Amendment required to doco on Connecting JIRA applications to MySQL

            No work has yet been logged on this issue.

              3d67fbf19c8a Maria Sobińska
              rstadler@atlassian.com Russell Stadler (Inactive)
              Affected customers:
              2 This affects my team
              Watchers:
              7 Start watching this issue

                Created:
                Updated:
                Resolved: