Hi,
see also Matomo on DigitalOcean Managed Database Cluster MySQL 8 - sql_require_primary_key error
The error message pretty much says what the issue is:
Matomo creates temporary MySQL tables for a few things and as they only have one column, they don’t really need a primary key, so they don’t have one.
But if you set your MySQL up to never allow a table without a primary key (sql_require_primary_key), it won’t allow Matomo to create these tables.
This has been solved here:
https://github.com/matomo-org/matomo/pull/16290