You can easily set the time zone of your database by using an SQL command in phpMyAdmin 😊
In order to do so, you will need to open your databases via phpMyAdmin. You can check these articles for hPanel and cPanel for the full procedure.
Once in phpMyAdmin - click on SQL section:

Once in SQL section, insert the following command with the location of the time zone you would like to use, for example, SET time_zone = '+08:00';

Then simply click on the Go button and you are all done, you have successfully changed the time zone for your database
NOTES:
This will only change the time zone for the current MySQL session, after the current session ends time zone will be changed to a default one. For that reason, it's best to use the PHP function date_default_timezone function to set your own time zone for your website.