Thanks for posting!
This can be done by connecting to the MySQL server via ODBC. To do this, you'll need to download and install the MySQL ODBC driver from their site (http://dev.mysql.com/downloads/connector/odbc/5.1.html) and install it on the machine where FileMaker resides. Then, create a new System DSN on that same machine using that driver.
On Windows, a System DSN can be created in Control Panel -> Administrative Tools -> Data Source (ODBC).
For OS X 10.6, please see knowledge base answer #7360:
Once the System DSN is created for your MySQL database, you can import the data a few different ways. The most straightforward way would be to go through the File -> Import Records menu and select the ODBC Data Source menu item.
Please let me know if you'd like any clarification on the above.
Thank you very much for the answer.
Just to share my experience. what I did is: Install a MySQL DB to my hoster server, and install the MySQL ODBC that you mentioned into my local server which hosts FileMaker Server, and
set up a system dsn using that driver. then I can see the MySQL tables from my FileMaker Pro.
This works beautifully for me.
Thank you again,