Are you using Tableau's native MySQL connector or are you attempting to connect via ODBC? By the error message, I'd assume you're using ODBC. ODBC does have some limitations, so can you try using the native MySQL connector and let us know if that works?
Just try again without your ";" at the end.
In my experience, Tableau doesn't handle it.
Tell me if it works !
That works, thx so much!