I’am using Piwik since quiet va long time.For some reasons I had to delete and start again to Matomo.I’am also using WP-Piwik on wordpress which works fine. My problem is that I cannot login to Matomo as a superuser. When I login as anonymous, I can see everything works ok.
So why cannot I login as superuser?
Any help would be welcome!
Can you provide an error message?
Ok, please try to use the “Forgot password” (Mot de passe perdu) function first, if that doesn’t work try How do I change the Super User’s password when password recovery emails are not sent? - Analytics Platform - Matomo
That’s what I did, get a mail as answer, but without any result.
So, with the new password and the given email adress you were unable to login?
Sorry but this doesn’t work neither:
**Requête SQL : **
UPDATE `matomo_user` SET `password` = "$2y$10$FdIxj5r/oQn6F6ezMtv/W.QjaajouskINZY.buhYLpOR5pIpjRwNi" WHERE `login` = ‘foodstyling’ AND superuser_access = 1
#1054 - Champ '‘foodstyling’' inconnu dans where clause
You should be using normal quotes ->
'<- or ->
"<- instead of typographical quotes around
Thanks, the query is ok now, but still no access with admin and changeMe as credentials
I temporarily made this hidden, as you posted username and password.
With the SQL query you changed the password of the
So you need to login with
The query is working now, but still no access, admin and changeMe
Thanks for your quick answer, but still not working.
It seems like you have now given your
anonymous user admin access. (Which means that everyone opening
https://www.foodstyling.be/matomo/ has full admin access on the site.
I’d recommend you take a look at the
matomo_user MySQL table, set the anonymous user to non-admin there and then login using the
Now you enter
foodstyling in the first box and
changeMe in the second box.
It works for me, so if it doesn’t for you, please try it with a different browser.
Finally I can login with Firefox, but not with Safari mac (maybe a cooky?)
Thannks for your help!
Please update your username and password and reset your authToken immediatly so that noone else can access them.
That’s what I did, I can login now with Chrome and Firefox but not with Safari. Any clue to fix that?