How to delete users using Linux commands?

Support & Bugs
1

I have an issue as lost password does not work to reset user. Can be deleted user using a Linux command?

Can be modified user’s password using a Linux command?

Which table name defines password and user if we manually delete users?

2

To my knowledge, Matomo does not provide a core Linux command to delete users or reset arbitrary user passwords.

The main user table is usually matomo_user, depending on your configured table prefix. The password column is password, the username column is login.

For emergency recovery of a Super User, Matomo documents an SQL password reset. For Matomo 3/4/5 you can set the Super User password to changeMe with:

UPDATE matomo_user
SET password = “$2y$10$FiknavjTDvUUTSMXGqgmUOfoKq2MkzlYt2/iu6cj02ZyI.40fUArC”
WHERE login = ‘admin’
AND superuser_access = 1;

Replace admin with your actual Super User login. Then log in with password changeMe and immediately change it to a secure password.

Do not manually delete users from the database unless you know all related tables. The recommended way is to restore Super User access and delete the user from Administration > System > Users. (Manage users FAQ - Analytics Platform - Matomo)

If you need CLI user management, there is a Marketplace plugin called User Console which adds commands such as user:list, user:delete and user:reset-password.

Hope this works for you.