How do I recover Super User access and give SuperUser permission to another account?

Sometimes it may happen that Super User access is lost. For example maybe there was only one Super User in Matomo and this person left on holiday, left the organization, or maybe even lost access to both their email account and their Matomo password.

When Super User access is lost, we need to grant another trusted Matomo user the Super User access. You can grant Super User permission to a given account by following the steps below:

  1. Connect to your MySQL database

  2. Run the following SQL query and replace the ‘username-here’ with the username for which to grant Super User permission:

    UPDATE `matomo_user` SET superuser_access = 1 WHERE `login` = 'username-here'

  3. Logout and login again as this username.

  4. You can now use Matomo as a Super User.

See also How do I change the Super User’s password when password recovery emails are not sent?

Previous FAQ: How do I change the Super User’s password when password recovery emails are not sent?