To change the Super User’s password when password recovery emails are not sent, follow the steps below.
If you use Matomo 3.0 or newer
-
Generate the secure password hash. On a linux server, run the following command:
php -r 'echo password_hash(md5("changeMe"), PASSWORD_DEFAULT) . "\n";'
-
Copy paste the output which will look like:
$2y$10$FiknavjTDvUUTSMXGqgmUOfoKq2MkzlYt2/iu6cj02ZyI.40fUArC
-
Connect to your Matomo (Piwik) database using a tool such as phpMyAdmin or direct Mysql access.
-
The following SQL query must be executed on your database. Replace the ‘admin’ with your Super User username.
UPDATE `matomo_user` SET `password` = "$2y$10$FiknavjTDvUUTSMXGqgmUOfoKq2MkzlYt2/iu6cj02ZyI.40fUArC" WHERE `login` = 'admin' AND superuser_access = 1
-
Login to Matomo using the following credentials:
login: admin password: changeMe
-
Click on the Administration link in the top menu, then “Personal Settings”, then change your password to a more secure one.
-
Check you are using the most up to date version of Matomo.
If you use Matomo 2.1 or newer:
- Connect to your Matomo database using a tool such as phpMyAdmin or direct Mysql access.
-
The following SQL query must be executed on your database. Replace the ‘admin’ with your Super User username. Note that it must be replaced twice in this SQL query.
UPDATE `matomo_user` SET `password` = MD5( 'changeMe' ), `token_auth` = MD5( CONCAT('admin', password)) WHERE `login` = 'admin' AND superuser_access = 1
-
Login to Matomo using the following credentials:
login: admin password: changeMe
-
Click on the username link in the top menu, then change your password to a more secure one.
- Check you are using the most up to date version of Matomo.
If you use Matomo older 2.0.3 or older:
-
In your config.ini.php, change the [superuser] section to:
[superuser] login = "admin" password = "807ff71b3301262e222ad05e5b7c4325" email = "admin@example.org" salt = "ffd09b1b27ad925d2a3ca842947f391d"
-
Login to Matomo using the following credentials:
login: admin password: ChangeMe
-
Go to Administration -> User settings, then update your email and change the password, click Save.
-
Update Matomo to the latest version as soon as possible!
Related
See also How do I recover Super User access and give SuperUser permission to another account?