How to create Software Project, I see only Business

Jan Fajtl September 11, 2017

I have installed JIRA Software 7.5.0 on a fresh server. I don't see Software in project creation window. JIRA Software is licensed and seems to be ok. Any suggestions how to enable Software projects?JIRA1.pngJIRA2.png

1 answer

1 accepted

0 votes
Answer accepted
Jan Fajtl September 11, 2017

It was due to missing GRANT for JIRA database user.

In documentation here https://confluence.atlassian.com/adminjiraserver071/connecting-jira-applications-to-mysql-802592179.html the grants are

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

 But for MySQL server 5.7.19 it should be

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

After granting references and restart of JIRA service I can see and create Software projects.

Suggest an answer

Log in or Sign up to answer