This could be a permissions thing on the MySQL end. Also double check that you are indeed using a System DSN.
MySQL can limit connections based on IPaddress. Where ever the FileMaker client is run from will need to be granted access on the MySQL server (for the user.)
I've always used the same user in the FM ODBC settings as I did in the system ODBC settings.