Question
How i can enable innodb_large_prefix in MySQL 8
Answer
The innodb_large_prefix cannot be enabled, has been deprecated with MySQL 5.7.7 and now is removed.
Important Change; InnoDB: The following InnoDB file format configuration options were deprecated in MySQL 5.7.7 and are now removed:
-
innodb_file_format -
innodb_file_format_check -
innodb_file_format_max -
innodb_large_prefix
Please follow the MySQL 8 documentation.