Missing MySQL permissions in System Report about matomo-for-wordpress

[tsteur]

I can see how the FAQ might not be 100% relevant. I guess I linked to it because it shows how to grant permission GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, INDEX, DROP, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES ON matomo_db_name_here.* TO 'matomo'@'localhost'; but it's not clear. I will create a new FAQ and update the link.

Looking at the missing permissions it seems like the permissions could not be detected and it may be actually all fine. I will update the system check to not issue an error in that case.

Any chance you could execute in your database using the same DB user as WordPress uses this query and let us know the output?

SHOW GRANTS

[diegoaa]

mysql> SHOW GRANTS;
+--------------------------------------------------------------------+
| Grants for wpuserXXXXX@localhost |
+--------------------------------------------------------------------+
| GRANT USAGE ON * . * TO 'wpuserXXXXX'@'localhost' |
| GRANT ALL PRIVILEGES ON wpYYYYYYY.* TO 'wpuserXXXXX'@'localhost' |
+--------------------------------------------------------------------+
2 rows in set (0.00 sec)

[tsteur]

Awesome, thank you very much!

[tsteur]

fixed the issue in f576bbd

Thanks for your help