What should I do when the upgrade failed with « Syntax error or access violation: 1142 INDEX command denied to user »
Ask your sysadmin to GRANT your database user INDEX privilege. This is required to CREATE, DROP, and ALTER indexes, and allow Matomo (Piwik) to update successfully.