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

On-Premise

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

When superuser access is lost, you need to grant another trusted Matomo user with superuser access. You can grant superuser 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 superuser.

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

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