MySQL 8 - ERROR 1071 (42000) in file: 'create_db_tables.sql': Specified key was too long; max key length is 1000 bytes
A problem has been reported on the forum when using MySQL community 8. https://www.tango-controls.org/community/forum/c/general/installation/tango-9-windows-demo-installation-problem/?page=1#post-3999
It looks like a workaround can be to edit create_db.sql.in and to replace the following line
CREATE DATABASE tango;
with
CREATE DATABASE tango DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;
Workaround found on https://stackoverflow.com/questions/20014106/how-to-create-this-table-1071-specified-key-was-too-long-max-key-length-is/42497309
Deeper investigations are needed to see if this workaround is the right approach and if it works with MariaDB and older MySQL versions.