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

            Maria Sobińska made changes -
            Resolution New: Fixed [ 1 ]
            Status Original: Gathering Impact [ 12072 ] New: Closed [ 6 ]
            Oksana Levchuk made changes -
            Remote Link New: This issue links to "Bugfixing & feedback processing in Jira DC: JRASERVER-63725 (Trello)" [ 665499 ]
            Oksana Levchuk made changes -
            Status Original: Needs Triage [ 10030 ] New: Gathering Impact [ 12072 ]
            Oksana Levchuk made changes -
            Assignee Original: Tomasz Prus [ a803384f6b1d ] New: Maria Sobińska [ 3d67fbf19c8a ]
            SET Analytics Bot made changes -
            UIS Original: 2 New: 0
            SET Analytics Bot made changes -
            UIS New: 2
            Andriy Yakovlev [Atlassian] made changes -
            Assignee Original: Tomasz Bartyzel [ tbartyzel ] New: Tomasz Prus [ a803384f6b1d ]
            Andriy Yakovlev [Atlassian] made changes -
            Assignee Original: Jacek Krawczyk [ 2cd4b6cecf0f ] New: Tomasz Bartyzel [ tbartyzel ]
            Andriy Yakovlev [Atlassian] made changes -
            Priority Original: High [ 2 ] New: Low [ 4 ]
            Jacek Krawczyk (Inactive) made changes -
            Assignee Original: Tomasz Bartyzel [ tbartyzel ] New: Jacek Krawczyk [ 2cd4b6cecf0f ]

              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: