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'

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

            Matt Doar added a comment -

            https://confluence.atlassian.com/adminjiraserver0813/connecting-jira-applications-to-mysql-5-7-1027137456.html does mention
            "MySQL 5.7.6 and later (must also include the REFERENCES permission):"

            Matt Doar added a comment - https://confluence.atlassian.com/adminjiraserver0813/connecting-jira-applications-to-mysql-5-7-1027137456.html does mention "MySQL 5.7.6 and later (must also include the REFERENCES permission):"

              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: