I'm having an issue with Jira using mysql. It was working flawlessly but now after migrating this stack to a different machine it quit working. I can login just fine to mysql with the credentials in dbconfig.xml. The host and port are returning mysql login prompts when I telnet to them so I'm stumped as to where I need to look next to solve this problem.
Thanks for posting back with your solution. That is very strange. The database password would be stored in cleartext in the dbconfig.xml file. I'm curious if perhaps you were changing between operating systems (Windows to Linux or vice versa) and if these two operating systems were using different character encodings for certain characters.
Without revealing your database credentials, does your username/password for the database contain any special characters? Anything aside the common characters of A-Z, a-z, 0-9, !@#$%^&*()-_;',. character sets?
MySQL is the one supported database for Jira that Atlassian cannot bundle the database driver for (due to licensing restrictions). Instead you, as the admin of your system, have to download this jdbc driver separately from MySQL's site and copy this .jar file into your $JIRAINSTALL/lib/ folder and restart Jira, before Jira can make any connections to that database type.
This is explained in the Connecting Jira to MySQL database documentation.
Also when you download the driver, make sure you get the JDBC Connector/J 5.1 version, and not the 6.x or 8.x jdbc driver versions. Jira won't work with these newer database/drivers yet.
Jira is a great tool to use across different departments. Forget that paperwork – switch to Jira and get that tasks done smoothly. Marketing Jira allows for a complete digital transformation of you...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events