error creating sync tables in mysql

Exception in thread "main" java.lang.RuntimeException: Error running scriptException in thread "main" java.lang.RuntimeException: Error running script at edu.internet2.middleware.grouper.ddl.GrouperDdlUtils.changeDatabase(GrouperDdlUtils.java:1277) at edu.internet2.middleware.grouper.app.tableSync.TableSyncCreateTables.createSyncTablesIfNotExist(TableSyncCreateTables.java:42) at edu.internet2.middleware.grouper.app.tableSync.TableSyncCreateTables.main(TableSyncCreateTables.java:34)Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 767 bytes at org.apache.tools.ant.taskdefs.SQLExec.execute(SQLExec.java:691) at edu.internet2.middleware.grouper.ddl.GrouperDdlUtils.changeDatabase(GrouperDdlUtils.java:1273) ... 2 moreCaused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 767 bytes at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:422) at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) at com.mysql.jdbc.Util.getInstance(Util.java:408) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2480) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2438) at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:845) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:745) at org.apache.tools.ant.taskdefs.SQLExec.execSQL(SQLExec.java:786) at org.apache.tools.ant.taskdefs.SQLExec.runStatements(SQLExec.java:756) at org.apache.tools.ant.taskdefs.SQLExec$Transaction.runTransaction(SQLExec.java:1058) at org.apache.tools.ant.taskdefs.SQLExec$Transaction.access$000(SQLExec.java:988) at org.apache.tools.ant.taskdefs.SQLExec.execute(SQLExec.java:672) ... 3 more