REFERENCES command denied to user <USERNAME> for table 'AO_5FB9D7_AOHIP_CHAT_LINK'

[briangreenedev]

Environment:

Jira Software

MySQL 5.7.29

Ubuntu 18.04

I did the following to try to solve the issue:

I updated the user permissions for the database user with

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

FLUSH PRIVILEGES; 

Restarted mysql service

Restarted jira service

I still get the same error whenever I do anything related to projects or issues.

[briangreenedev · Accepted solution]

I fixed my issue.

When I thought I was restarting Jira, it was actually failing. I made sure Jira restarted and after it did, my changes had taken effect.