Data Modeller with MySQL 8.4

BIZ TMS XData
1

I cant seem to get the Data Modeller work with MySql 8.4. It is using a different port 3080. I tried the variations for Mysql, but it didnt work.

  • The Name is MySQL84-3308 and it runs on port 3308.

20.07.2025_00.41.22_REC
20.07.2025_00.41.22_REC782×518 18.9 KB

Is there a way I can get it working? It works with my XData Application suite, just not with the Data Modeller

2

These are just parameters that are passed to the underlying database connection component, which happens to be a TFDConnection under the hood.

This looks like simply your server can't be found from your computer. Are you sure you are able to connect to such MySQL server using a different tool, like MySQL Workbench, or even a Delphi application using TFDConnection?

3

For this project I had to shift to MySql from MariaDB as thats what the client has.

It works from MysqlWorkbench which shows Maria DB and MySQl at different ports and I can connect to either.

It works from XData server, where all I had to change in the Firedac parameters is the port.

Database name, username and password are the same as before, Just the port has changed from 3306 to 3308.

  1. I couldn't change the MariaDB port as that's used in 6 PHP applications/websites. It was quicker and safer to change the MySQL port.
  2. Does it have something to do with 32 bit/ 64 drivers perhaps?
  3. I gave it that name so I would know remember version and port I am using

MySql Workbench

25.07.2025_23.51.00_REC
25.07.2025_23.51.00_REC971×516 22 KB

Xdata Server

25.07.2025_23.51.42_REC
25.07.2025_23.51.42_REC637×302 9.41 KB

Tables compared some table names have changed from MariaDB, so I know it the correct one. And its fetching the field changes as well.

25.07.2025_23.59.00_REC
25.07.2025_23.59.00_REC693×744 52.9 KB

4

What are the exact setting you have in your mysqlworkbench and xdata server?