CODE EXAMPLE FOR PHP

ERROR 1071 (42000) at line 51: Specified key was too long; max key length is 767 bytes

sudo nano /etc/my.cnf.d/server.cnf

[mysqld]
innodb_large_prefix=true
innodb_file_format=barracuda
innodb_file_per_table=true

sudo systemctl restart mariadb