...
In general you will find the mysql configuration in "/etc/mysql/mysql.conf.d/mysqld.cnf" or in "/etc/mysql/my.cnf" or a similar file.
Charset and Collation
See
Timezone
Ensure that the timezone of MySQL is the same as the timezone configured in apache php and CLI php.
...