Connection failed: Driver for the database MySQL not found. Ensure it is installed in the 'lib' dire

[Projecti VaShona]

I am trying to connect Jira to MySQL, this is the error message I get

Attempting to connect to localhost:3306/jira

*** Connection failed: Driver for the database MySQL not found. Ensure it is installed in the 'lib' directory.

If you are upgrading a standalone distribution of JIRA, this may be due to the fact that JIRA no longer ships with MySQL drivers.

Please visit <a href="https://docs.atlassian.com/jira/jadm-docs-0713/Connecting+Jira+applications+to+MySQL">Connecting Jira applications to MySQL</a> for more information.

I have this in my jira/bin

drwxr-xr-x  3 root root    4096 Feb  4 14:03 .

drwxr-xr-x 15 root root    4096 Feb  4 13:32 ..

drwxr-xr-x  2 root root    4096 Feb  4 13:32 apr

-rw-r--r--  1 root root   34985 Jan 29 13:19 bootstrap.jar

-rw-r--r--  1 root root   16235 Jan 29 13:19 catalina.bat

-rwxr-xr-x  1 root root   23652 Jan 29 13:19 catalina.sh

-rw-r--r--  1 root root    1703 Jan 29 13:19 catalina-tasks.xml

-rw-r--r--  1 root root     778 Jan 29 13:19 check-java.bat

-rwxr-xr-x  1 root root     963 Jan 29 13:19 check-java.sh

-rw-r--r--  1 root root   25145 Jan 29 13:19 commons-daemon.jar

-rw-r--r--  1 root root  207125 Jan 29 13:19 commons-daemon-native.tar.gz

-rw-r--r--  1 root root    1270 Jan 29 13:19 config.bat

-rwxr-xr-x  1 root root    1219 Jan 29 13:19 config.sh

-rw-r--r--  1 root root    2040 Jan 29 13:19 configtest.bat

-rwxr-xr-x  1 root root    1922 Jan 29 13:19 configtest.sh

-rwxr-xr-x  1 root root    8509 Jan 29 13:19 daemon.sh

-rw-r--r--  1 root root    2091 Jan 29 13:19 digest.bat

-rwxr-xr-x  1 root root    1965 Jan 29 13:19 digest.sh

-rw-r--r--  1 root root     315 Jan 29 13:19 display-help.bat

-rwxr-xr-x  1 root root     349 Jan 29 13:19 display-help.sh

-rwxr-xr-x  1 root root    1496 Jan 29 13:19 install_linux_service.sh

-rw-r--r--  1 root root     539 Jan 29 13:19 jirabanner.txt

-rw-r--r--  1 root root  138486 Jan 29 13:19 jira-configurator.jar

-rw-r--r--  1 root root 1007505 Feb  4 13:58 mysql-connector-java-5.1.47-bin.jar

-rw-r--r--  1 root root 1007502 Feb  4 14:03 mysql-connector-java-5.1.47.jar

-rw-r--r--  1 root root    7927 Jan 29 13:19 service.bat

-rw-r--r--  1 root root    3460 Jan 29 13:19 setclasspath.bat

-rwxr-xr-x  1 root root    3680 Jan 29 13:19 setclasspath.sh

-rw-r--r--  1 root root    5437 Jan 29 13:19 setenv.bat

-rwxr-xr-x  1 root root    4696 Feb  4 13:32 setenv.sh

-rwxr-xr-x  1 root root    1927 Jan 29 13:19 setup_user.sh

-rw-r--r--  1 root root    2020 Jan 29 13:19 shutdown.bat

-rwxr-xr-x  1 root root    1902 Jan 29 13:19 shutdown.sh

-rw-r--r--  1 root root     866 Jan 29 13:19 start-jira.bat

-rwxr-xr-x  1 root root    1605 Jan 29 13:19 start-jira.sh

-rw-r--r--  1 root root    2022 Jan 29 13:19 startup.bat

-rwxr-xr-x  1 root root    1904 Jan 29 13:19 startup.sh

-rw-r--r--  1 root root      83 Jan 29 13:19 stop-jira.bat

-rwxr-xr-x  1 root root     854 Jan 29 13:19 stop-jira.sh

-rw-r--r--  1 root root   96168 Jan 29 13:19 tomcat8.exe

-rw-r--r--  1 root root  114600 Jan 29 13:19 tomcat8.exe.x64

-rw-r--r--  1 root root  118184 Jan 29 13:19 tomcat8w.exe

-rw-r--r--  1 root root   49336 Jan 29 13:19 tomcat-juli.jar

-rw-r--r--  1 root root  408967 Jan 29 13:19 tomcat-native.tar.gz

-rw-r--r--  1 root root    4574 Jan 29 13:19 tool-wrapper.bat

-rwxr-xr-x  1 root root    5483 Jan 29 13:19 tool-wrapper.sh

-rwxr-xr-x  1 root root     141 Feb  4 13:32 user.sh

-rw-r--r--  1 root root    2026 Jan 29 13:19 version.bat

-rwxr-xr-x  1 root root    1908 Jan 29 13:19 version.sh

[Andy Heinzer · Accepted solution]

Hi,

The error message is indicating that you need that mysql .jar file to be in the $JIRAINSTALL/lib/ folder.  From your post, I can see you have it in the $JIRAINSTALL/bin/ folder instead.   You should be able to move that file to the /lib/ folder and you might need to restart Jira for this to take effect.

Cheers,

Andy

[Projecti VaShona]

You are 100% correct. I feel like a genius :/