How to reset mySQL database?



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!

(Lukas Winkler) #2


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)