Could not find driver with class name: com.mysql.cj.jdbc.Driver

[Mariano]

My company is redoing a JSM DC instance to a Debian 12 machine, we're having BIG trouble trying to get it to work.

(atlassian-servicedesk-5.17.1-x64.bin)

Whenever we try to setup the DB (Mysql 8.0) on the welcome page we get this error:

We have both Cloud and DC (legacy) servers. I'm more knowledgeable in Cloud, but I have spun up a few DC instances before and never ran into this problem.

I downloaded the Connector/J 9.0.0 and 8.4 from MySQL site, copied into

`/opt/atlassian/jira/lib` and nothing, I did `dpkg -i mysql-connector-j_8.4.0-1debian12_all.deb` and I get a good output but still nothing.

I even went as far as copying `/usr/share/doc/mysql-connector-j` to the Jira lib folder, restart Jira but still that damn error: Could not find driver with class name: com.mysql.cj.jdbc.Driver

Anyone know how to force Jira to read this Driver? And where can I get it from?

Thanks in advance.

**** EDIT ****

I just found some old Confluence setup guide that reads the following:

"

1. Stop Confluence.
2. Head to Database JDBC Drivers and download the appropriate driver for MySQL 8. The driver file will be called something like mysql-connector-java-8.0.xx-bin.jar 

I do have a file reading mssql-jdbc-9.2.1.jre8.jar and that's it. Will look for some mysql-connector-java file 🤔

[Florian Bonniec · Accepted solution]

Hi @Mariano Edvardsson 

You need add the connector into the lib directory then restart the application. Make sure that permission on the file are correct so JIRA will be able to read/load the file on startup.

You can download the driver from there 

Supported platforms | Administering Jira applications Data Center 9.17 | Atlassian Documentation

Regards

[Mariano]

Thank you!  That worked!!