nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Vinod Bathi

I have installed Jira as service, while I was trying to set up the database I am getting an error "Could not find driver with class name: com.mysql.jdbc.Driver" please help in this case.

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

Server: Ubuntu 18.04.3 (LTS) x64

Database: mysql 5.7

jira version: 8.7

Accepted answers

Alexis Robert

Hi @Vinod Bathi ,

this is because the MySQL driver is not bundled with the Jira installation package. You need to download it here : https://dev.mysql.com/downloads/connector/j/5.1.html

And then unzip it and move the jar file in <Jira-installation-directory>/lib

You can find the full procedure here : <a href="https://confluence.atlassian.com/adminjiraserver/connecting-jira-applications-to-mysql-5-7-966063305.html" target="_blank" rel="nofollow noopener noreferrer">https://confluence.atlassian.com/adminjiraserver/connecting-jira-applications-to-mysql-5-7-966063305.html</a>

Let me know if this helps, 

--Alexis

All comments

Alexis Robert

Hi @Vinod Bathi ,

this is because the MySQL driver is not bundled with the Jira installation package. You need to download it here : https://dev.mysql.com/downloads/connector/j/5.1.html

And then unzip it and move the jar file in <Jira-installation-directory>/lib

Let me know if this helps, 

--Alexis

Vinod Bathi

Hi @Alexis Robert ,

After following your answer, my error has been changed, a new error has been thrown.

"Error connecting to database

Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.

hostname: Temporary failure in name resolution"

Alexis Robert

Hi @Vinod Bathi ,

in "hostname", just put "localhost" (without the quotes) and it should all be good.

Vinod Bathi

Hi @Alexis Robert

updated as per your instruction, got an error, please find the screenshot, after the error, by following the Connecting Jira applications to MySQL 5.7, i have updated my.cnf , unable to start mysql server

Odyssey Shipping Ltd

I've done all this but still receiving the original error:

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

The documentation is not crystal clear.

- I d/l the mysql gzip file

- moved the file to /opt/atlassian/jira/lib/

- ran the tar command

- it created a directory: mysql-connector-java-5.1.49

- restarted jira

- same error

Yassin BEN-NACEUR _FlowZess_

Please follow these steps: i had the same problem and this helped:

- Go to https://dev.mysql.com/downloads/connector/j/8.0.html

- Choose "Platform independent" instead of (Ubuntu, ...)

- Download the ZIP File: Platform Independent (Architecture Independent), Compressed TAR Archive

- Unzip it

- Copy the .JAR file from ~/Downloads/mysql-connector-java-8.0.23/mysql-connector-java-8.0.23.jar to your installation directory (/opt/atlassian/jira/lib)

- make sure the file is there: ll /opt/atlassian/jira/liba | grep mysql

- restart jira: Go to /opt/atlassian/bin and run ./stop-jira.sh then run ./start-jira.sh

shujiYuan

thank u, you save my day.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira

jira-software

jira-software-server

atl-gruland

mysql

jdbc