Hi,
I cannot connect to MySQL database with Matomo because “The server time zone value ‘PDT’ is unrecognized”. How can I reset the database in Matomo? I input some database settings when I first installed Matomo, how to change it?
Thank you!
Hi,
Most matomo settings are stored in the piwik_option or matomo_option table and I think the option_name SitesManager_DefaultTimezone is where the initial time zone is stored.
But I think this error is coming from your database and maybe you need to change your database config to fix this (but not sure as I have not seen this error before)