Can't connect to MySQL/MariaDB(Xampp) to define a Data Source

Question

1. Before installing Knowage, I've installed XAMPP. The installation process finished without any issue and configured correctly the database (It creates knowage_demo and foodmart_demo in my MariaDB/MySQL database). I can get into my DB at http://localhost/phpmyadmin/, additionally, I can get into Knowage at http://localhost:8080/knowage.
   My problem is when I want to add a new Data Source which is located in the same MariaDB/MySQL database:
   I Used:
   URL= jdbc:mysql://localhost/MyDataBase
   Driver= com.mysql.jdbc.Driver

   I also used:
   URL= jdbc:mysql://localhost:3306/MyDataBase
   Driver= com.mysql.jdbc.Driver

   But always says:
   "Error

   Connection Test failed, please look for more details in log file and check Your parameters"

Comments

Dear

Most probably inside knwoage.log you can find more information.

Could you check if there is the jdbc driver on /Knwoage-CE/lib

Best Regards

A

Answer 1

I am using mySQL 8.0.16. jdbc:mysql://localhost:3306 worked for me.

The used account needs to have Authentication Type: Standard (caching_sha2_password doesn't seem to work).

Good luck!

Edit: After installation completion, I get a "HTTP Status 500 - The server encountered an internal error that prevented it from fulfilling this request." from Apache Tomcat. Is mySQL 8 incompatible?