Error in creating new data adapter in Jaspersoft Studio 6.0.4

using jaspersoft studio 6.0.4.

 

when createing new data adapter, we are able to connect with my mysql database (MYSQL 5.6) running in localhost and got test connection successfull.

 

but i'm unable to select table from database using selection query "SELECT * FROM <mytablename>"

 

i got error mgs show as below

 

"Erreur de syntaxe près de 'OPTION SQL_SELECT_LIMIT=DEFAULT' à la ligne 1"

 

please help to solve the problem