Configuring jira with MYSQL

[Karim Belhadj]

hello team

I tried to configura jira with mysql database so , it work fine and , tables was created in, my database , but an error occur when i start jira . The picture below decribe the problem.

Can someone help ?

Regards

[miikhy]

Hi @Karim Belhadj ,

Can you please let us know which database encoding/collation you chose when creating the database?

There's a resolved support request (https://jira.atlassian.com/browse/JRASERVER-37929) which have been fixed after changing the charset to the one recommended.

Let us know if it helped!

Cheers

[Karim Belhadj]

@miikhy  , this request made my day , the problem was in the collaption . i

Thank you

[miikhy]

Great!

Have fun with Jira!

Cheers

[Milan Chheda [INFOSYSTA]]

Probably, the database is damaged/corrupted/unreadable. The logs mentions that the table 'pluginstate' doesn't exist.

I believe, the best thing to do here would be to go back and do a clean installation. And before installation, checking and making sure that database is setup correctly with collation, user, proper privileges, etc. You can read about JIRA with MySQL here: https://confluence.atlassian.com/adminjiraserver0713/connecting-jira-applications-to-mysql-964983095.html