How to connect Mendix to a MySQL localhost database?
0
I'm a graduate student currently hoping to use Mendix for my final project. I need the app to be able to reference an exterior database.I've installed the external database connector, and followed the tutorial steps for connecting it to the database. Originally, I was using a localhost PostgreSQL database. However, my attempts to connect to it kept failing (E005). I then switched to MySQL, hoping this would solve the problem, but it so far has not. I have tried both component input and the full connection string, and double checked that the database is running. No luck.My most recent hunch was that the database itself did not have JDBC, and I've since placed the relevant .jar file for JDBC in many different project folders (including lib, userlib, etc.) to try to get it to work. It still refuses to connect (E005), and I've run out of ways to attempt fixing it.Am I doing something wrong, missing a component, or something else? I'm using Mendix 11.6.2, the most recent version of the connection plugin, and MySQL 8.0.
asked
Clara Mosentine
1 answers
0
Hello,
I think the standard is still postgresql and you should stick to that because it's most commonly used!
Please refer below link, I think the below blog can help you with steps but you can do it in your local machine and not on cloud environment