500 errors displayed while navigating in Jira server

[Srujana p]

Tried Add-on Steps as well as 

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


but no result 

still 500 error page when we click on the link

[Daniel Ebers]

The error 500 is a quite generic one. It could be related to a database issue but just from getting this error it is hard to say if the query you executed on the database is of help or not.

The log files of Jira (atlassian-jira.log) will guide your way to trouble shoot the error.

Without knowledge of the contents of log files and your setup it is nearly impossible to state what the error 500 is caused by and how it can be fixed.

Cheers,
Daniel