[SOLVED] MySQL / MariaDB Specified key was too long; max key length is 767 bytes

[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.cnf

Include 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 = Barracuda

Restart MariaDB / MySQL

systemctl restart mysql

Thats it now the error should be resolved.

Keywords:

long max,

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