Problem connecting to MySQL 8 with Knowage installed in Ubuntu, but not in Windows

Question

I am recently having this issue

I have 2 instances of Knowage CE installed. One in Ubuntu in 18.04 running Knowage 7.2.0 CE and another in Windows 10 unning Knowage 6.4.4 CE. Using Windows 10, I have no problem connecting to my managed MySQL 8.0.20 database  in Digital Ocean  but I am having a problem connecting from my Ubuntu server running in a Digital Ocean droplet. 

I have been able to connect to MySQL 8.0.XX databases from my Knowage installed in Ubuntu previously using Knowage 6.4.4 but, recently I am having issues running / starting that version in Ubuntu that is why I tried switching to 7.2

I am using these JDBC Driver for MySQL 8: mysql-connector-java-8.0.15 . I also tried mysql-connector-java-8.0.21 but still cannot connect.

In the driver field: com.mysql.cj.jdbc.Driver

From my Windows 10 machine 

From my Ubuntu Server

Answer 1

I fixed the issue by simply replacing the mysql-connector-java-8.0.15.jar file I downloaded from here https://jar-download.com/artifacts/mysql/mysql-connector-java

I used the jar file from one of my successful installation. It's working now

Comments

It works for me!