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

In some cases, Super User access may no longer be available. For example, the only Super User might be on leave, have left the organisation, or lost access to both their email account and Matomo password.

When Super User access is lost, you need to grant another trusted Matomo user with 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?