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?
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.