[SOLVED] MySQL / MariaDB Specified key was too long; max key length is 767 bytes
Error :
mariadb specified key was too long
Specified key was too long; max key length is 767 bytes
SOLUTION:
Edit the Global Maria DB / MySQL config file:
nano /etc/mysql/my.cnfInclude below config at the end of the file:
innodb_file_format = Barracuda
innodb_file_per_table = on
innodb_default_row_format = dynamic
innodb_large_prefix = 1
innodb_file_format_max = BarracudaRestart MariaDB / MySQL
systemctl restart mysqlThats it now the error should be resolved.
Keywords:
MySQL, MariaDB, Specified, key, was, too, long; max, key, length, is, 767, bytes
MySQL / MariaDB Specified key was too long; max key length is 767 bytes
