Somebody to help please -Mendix Database Connector with Mysql 8.x

0
Hi, Everybody . I’m very new to Mendix ,and Mendix is amazing . I hava trouble with the Database Connector .  I wanna using Local Mysql database to Mendix . But I have failed many times . I still can’t query the data . Could you please help me .   My local DB is : 127.0.0.1:3306/mydatabase User: root Password:root    can anyone tell me how to fill the DB connector ? 1\ jdbc Url :  2\User name： 3\ Password： 4\sql： 5\ Result object:   My answer is : 1\ jdbc Url : 'jdbc:mysql://localhost:3306/mydatabase 2\User name：’root’ 3\ Password：’root’ 4\sql：’select * from book1’ 5\ Result object: Newentity   Thanks for your help . with you have a good day .  
asked
2 answers
0

Hi, 

I am not sure what you are trying to achieve but since Mendix v8 it is possible to query the database without manually setting up a connection.

https://apidocs.mendix.com/7/runtime/com/mendix/datastorage/DataStorage.html

Hope this helps,

Andrej

answered
0

Hi,

At the very initial steps, you should do a correct configuration of your database. Are you sure it has been configured properly?

answered