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.