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 

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!!