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

 <span>GRANT&nbsp;</span><span>SELECT</span><span>,&nbsp;</span><span>INSERT</span><span>,&nbsp;</span><span>UPDATE</span><span>,&nbsp;</span><span>DELETE</span><span>,&nbsp;</span><span>CREATE</span><span>,&nbsp;</span><span>DROP</span><span>,&nbsp;</span><span>REFERENCES</span><span>,&nbsp;</span><span>ALTER</span><span>,&nbsp;</span><span>INDEX</span> <span>on</span> <span><</span>JIRADB<span>></span><span>.</span><span>*</span> <span>TO</span> <span>'<USERNAME>'</span>@'localhost<span>' IDENTIFIED BY '</span><span><</span>PASSWORD<span>></span>'<span>;<br><br>FLUSH PRIVILEGES;</span>

Restarted mysql service

Restarted jira service

 

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

briangreenedev

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.