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!


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)