Getting error 1071: Specified key was too long; max key length is 767 bytes for the following tables:
     mdl_conf_nam_uix on mdl_config (name)
     mdl_capa_nam_uix on mdl_capabilities(name)
     mdl_rolecapa_rolconcam_uix on mdl_role_capabilities (roleid, contextid, capability)
     mdl_gradoutc_cousho_uix on mdl_grade_outcomes (courseid, shortname)
     mdl_tag_nam_uix on mdl_tag
     mdl_taginst_iteitetab_uix on mdl_tag_instance (itemtype, itemid, tagid)
     mdl_gradsett_counam_uix on mdl_grade_settings (courseid, name)
     mdl_webdlock_dok_uix on mdl_webdav_locks (token)
Main databases not set up successfully

     mdl_scorscoetrac_usescosco_uix on mdl_scorm_scoes_track (userid, scormid, scoid, attempt, element)
scorm tables could not be set up successfully

Will not let me continue. Have tried changing the mysql default to utf8 still same error. Tried changing default as well as moodle database to latin1 still same error. Did clean installs with each change. Cannot move forward from here. Have attached create unique index errors.