ADVISABLE TO WORK ON WINDOWS 64BIT platform (default is Win32)
Add TFDPhysMySQLDriverLink
leave VendorHome as blank
edit VendorLib to path and file of the DLL file
Add TFDConnection
double click to edit credentials
For the DLL Files:
make sure the DLL is correctly set, Windows-64bit platform need x64 DLL
Solutions:
Copy Query to Memtable