What is version of MySQL that compatible with Mendix?

0
Hi,  I trying to use Database Connector by following steps. It work fine with MSSQL but does not work for MySQL. Please suggest me what is the compatible version between MySQL, Mendix? Mendix = 8.9.0 (build 5487) MySQL = 8.0.20   Remark: - I already copy mysql-connector-java-8.0.20.jar file to userlib folder under Mendix project. - URL = jdbc:mysql://localhost:3306;database=datadict; - I use in local server, not on cloud.  
asked
2 answers
0

According to here: https://docs.mendix.com/refguide/system-requirements#1-introduction

MySQL 5.7, 8.0

What is the error you are getting?

Regards,

Ronald

 

answered
0

Got it! 

I use the wrong URL, the correct one is

jdbc:mysql://localhost/datadict

- localhost = your host name or IP Address.

- no need to specify port 3306.

- datadict = my database schema.

- Don’t use semi-colon (;) at the end of URL. → Very IMPORTANT! (I will get error immediately  if I put ; at the end of URL)

- no need to put any .jar file of MySQL to userlib folder (I think it may already supported).

answered