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.
It looks like you're new here. Sign in or register to get started.
