Connecting mendix to MySQL database

0
I am attempting to connect my mendix application to a MySQL database. I am using the project configuration to set the database which I also have some questions on : Type: MySQL/MariaDB URL: IP:Port (its on the local network so I have the IP address and the port listed as the URL should I include anything other than the IP and port?)  name: Schema_name (Is the the name of the schema or the database where the schemas are located?) use integrated security: NO (won’t let me change this) username: username (the default is root) password: password (this is for the connection) I have attempted to connect and I get the same error back: Opening JDBC connection to Some(IP:PORT) failed with SQLState: 28000 Error code: 1045 Message: Access denied for user 'Username'@'tyr-rl-hj9cjm2.corp.irco.com' (using password: NO), giving up...(4/4)  I am not sure why is says using “password NO “ I supplied it with a password. I am not sure how to progress on this, I tried with Mendix version 8.4 but found issues in the release notes so I am now on Mendix 7.23.9 and I am still getting the same error.  
asked
1 answers
4

Have you checked on the MySQL database that the user you are using is allowed to accept connections from other hosts then localhost? Is there maybe a firewall? Have you tested your connection to the mysql server from your current machine with a different tool to make sure it is working?

answered