Debug info:

 Index column size too large. The maximum column size is 767 bytes.

CREATE TABLE mdl_config (

id BIGINT(10) NOT NULL auto_increment,

name VARCHAR(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',

value LONGTEXT COLLATE utf8mb4_unicode_ci NOT NULL,

CONSTRAINT PRIMARY KEY (id)

, UNIQUE KEY mdl_conf_nam_uix (name)

)

ENGINE = InnoDB

DEFAULT COLLATE = utf8mb4_unicode_ci ROW_FORMAT=Compressed

COMMENT='Moodle configuration variables'

;

CREATE TABLE mdl_config_plugins (

id BIGINT(10) NOT NULL auto_increment,

plugin VARCHAR(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'core',

name VARCHAR(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',

value LONGTEXT COLLATE utf8mb4_unicode_ci NOT NULL,

CONSTRAINT PRIMARY KEY (id)

, UNIQUE KEY mdl_confplug_plunam_uix (plugin, name)

)

ENGINE = InnoDB

DEFAULT COLLATE = utf8mb4_unic

default-character-set = utf8mb4 

innodb_file_format = Barracuda 

innodb_file_per_table = 1 

innodb_large_prefix 

character-set-client-handshake = FALSE

character-set=server= utf8mb4

collation-server = utf8mb4_unicode_ci 

default-character-set = utf8mb4