Connecting Jira applications to MySQL : Error 1064

Question

I installed MySQL , mysql-installer-community-5.7.27.0 After installed, it showed MySQL 5.7 Command Line Client. I tried to connect Jira to MySQL using the the below instructions but both failed. a) For MySQL 5.5, MySQL 5.6, and MySQL 5.7.0 to MySQL 5.7.5: GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER,INDEX on .* TO ''@'' IDENTIFIED BY ''; flush privileges; b) For MySQL 5.7.6 and above, you must also include the REFERENCES permission: GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,REFERENCES,ALTER,INDEX on .* TO ''@'' IDENTIFIED BY ''; flush privileges; Both errors are similar, Error 1064. a) For MySQL 5.5, MySQL 5.6, and MySQL 5.7.0 to MySQL 5.7.5: Error 1064 mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER,INDEX on .* TO ''@'' IDENTIFIED BY '';flush priviledges; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.* TO ''@'' IDENTIFIED BY ''' at line 1 b) For MySQL 5.7.6 and above, you must also include the REFERENCES permission: Error 1074 mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,REFERENCES,ALTER,INDEX on .* TO ''@'' IDENTIFIED BY '';flush privileges; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.* TO ''@'' IDENTIFIED BY ''' at line 1 The error started '.* TO ''@'' IDENTIFIED BY ''' What should I set ? Please help. Thanking in advance. Best regards.

JP _AC Bielefeld Leader_ · Answer

With = jiradb = jirauser = secretpw123 and = myserver.mydomain.com this would be: GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,REFERENCES,ALTER,INDEX ON jiradb.* TO 'jirauser'@'myserver.mydomain.com' IDENTIFIED BY 'secretpw123'; FLUSH PRIVILEDGES; This should work. Best JP

PVS · Answer

Hi @Nurul Zahrah Dzulkifly

Could You Please Refer The Document

https://confluence.atlassian.com/adminjiraserver/connecting-jira-applications-to-mysql-5-7-966063305.html

Thanks,

PVS