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 timezone you would like to use, for example, SET time_zone = 'Asia/Bangkok':

Then simply click on the Go button and you are all done, you have successfully changed the time zone for your database


Did this answer your question?