Error when creating projects

[Craig Sarsfield]

We were given these steps previously to resolve the issue with creating Projects:

To fix the project creation problem, we would recommend you to perform the following actions:

1. Please backup your JIRA's data.
2. Create a new database for your JIRA by using the following query in your MySQL database:
3. CREATE DATABASE jiradbnew CHARACTER SET utf8 COLLATE utf8_bin;
4. Grant the necessary permission for the user in your MySQL:
   [code}
   GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,REFERENCES,ALTER,INDEX on <JIRADB>.* TO '<USERNAME>'@'<JIRA_SERVER_HOSTNAME>' IDENTIFIED BY '<PASSWORD>';
   flush privileges;
5. Update the USERNAME, JIRA_SERVER_HOSTNAME & PASSWORD entry with your own entries.
6. Please stop your JIRA.
7. Access your <JIRAHOME> and rename the dbconfig.xml to olddbconfig.xml
8. Restart your JIRA and configure it with your new MySQL database (jiradbnew).
9. After configuring JIRA with the new database, please proceed to restore the backup that you have generated earlier.
10. After restoring the backup, please relogin to your JIRA and check whether you can create project in your JIRA.

Our IT is trying to implement and have a follow up item regarding step four.

Looking at the current users below the jiiradbuser already has all the permissions the command grants. I’m assuming I need to add the accounts listed in the Jira Service desk portal to the SQL accounts and grant those the specific permissions.

Can you let me know if his assumptions are correct?

[Henrique Bittencourt · Accepted solution]

Hi Craig!

I'm not able to view your previous support request so I'll move further with the information that we have here (probably the issue was your database collation, so you'll need to create a new database with the correct one).

As far as I know, step #4 is asking to grant (at the database level) all those permissions to the user that Jira uses to connect to the database. So, if your Jira application is using the "jiiradbuser" - as you mentioned previously - and it already has those permissions granted, it's all set! There is no need to grant the permissions to others users within the database.

Best Regards.

[Craig Sarsfield]

Hi Henrique,

Thanks for the insight! I will give this a try.

[Craig Sarsfield]

Hi Hen - This helped and also we found a Collation error that seems to have been the culprit also, we cleared it up with the latin_swedish and now we can create projects

Thank Hen!