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.
Welcome to great meetings, with less work. Automatically record, summarize, and share instant recaps of your meetings with Loom AI.
Learn moreOnline forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.