JIRA crashes after MySQL database connection setup.

[Andrey Prozorov]

I set up MySQL database as per Atlassian guide on XAMP 7.2.11 on Mac server.

The install JIRA and set up connection to database. Connection test passes, then JIRA crashes saying there was some technical problem during my last operation. Here is a data provided on this page:

Technical details

Log's referral number: ecda1d9a-87a6-495a-9402-74bb05fe37ef

Cause

Referer URL: http://xserve:8080/secure/SetupDatabase!default.jspa

com.opensymphony.module.propertyset.PropertyImplementationException: SQL Exception while executing the following:SELECT ID, ENTITY_NAME, ENTITY_ID, PROPERTY_KEY, propertytype FROM propertyentry WHERE ENTITY_NAME=? AND ENTITY_ID=? (SELECT command denied to user 'admin'@'localhost' for table 'propertyentry')

[Rambabu Patina _Appfire_ · Accepted solution]

Hi @Andrey Prozorov,

The problem is with the permissions on the database. Please follow this article to resolve the issue.

Thanks,
Ram.