...
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
SeeThe charset is set on creation of the concrete DB in the next step.
Timezone
Ensure that the timezone of MySQL is the same as the timezone configured in apache php and CLI php.
...