Helpmonks Logo

MySQL: Specified key was too long; max key length is 767 bytes

MySQL: Specified key was too long; max key length is 767 bytes

I just ran into this issue while setting up a new client server with MySQL 5.6, well, Percona 5.6 in my case.

It looks like one has to explicitly allow long prefixes in 5.6. Something that was never needed in 5.5 or earlier version of MySQL.

In any case, adding:

innodb_large_prefix = on

to the my.cfn file solved it.

Hope it helps someone else out there ðŸ™‚

Nitai

Nitai

Founder & CEO of Helpmonks. Serial Entrepreneur. Getting things done.