How to make all timezones the same?

andipedia

Help me set all time zones both on server, mysqli, PHP to be the same. For server and PHP, I actually can make it, but not with MYSQL, which I can't find it.. I try SQL on the table I want : SET time_zone = 'Asia/Jakarta'; however : Unknown or incorrect time zone: 'Asia/Jakarta'

Is there a right solution?

aaP_hareeshnarayan1982

andipedia You can install linux tool to set server time.

aaPanel_Kern

setting will set MySQL's default timezone to the Asia/Jakarta timezone. Added this line to [mysqld] in the /etc/my.cnf configuration file:
default-time-zone='Asia/Jakarta'
Be sure to save the file and restart the MySQL service for the changes to take effect:
/etc/init.d/mysqld restart
Now, MySQL will use the Asia/Jakarta time zone as the default time zone. You can verify that MySQL's time zone is set correctly with the following command:
SELECT @@global.time_zone;
If the output is Asia/Jakarta, the time zone was set successfully.

andipedia

aaP_hareeshnarayan1982 It only set Server, not with mysql, I want to set mysql time zone

aaP_hareeshnarayan1982

andipedia Don't know what is your objective. But if you are referring to manage date and time for your application. This is how we do. We will have a table column for Date and time and we treat UK time (GMT + 0) as base time for storing Date and time and everything will be stored as GMT + 0 converted. For displaying based on user location this values are translated back and displayed.

andipedia

aaPanel_Kern I entered it mysql so it won't start. I tried starting, restarting, reloading but mysqli still won't start.

andipedia

aaPanel_Kern

Hello, is the problem solved? Is it normal if the added time zone configuration has not been removed?

andipedia

saya juga sudah coba default-time-zone='Asia/Jakarta' , default-time-zone=Asia/Jakarta

hilord

If your MySQL service doesn't start when you remove this default-time-zone line, it means this line is not the culprit and you have to solve the existing issue first. Nevertheless, if this line hurts MySQL, it could be because of lack of information for it and maybe you should have to populate the timezone-related tables as explained in MySQL documentation.

andipedia

aaPanel_Kern It's normal if I delete default-time-zone and has problems if I put it in. Or how to set the system time zone? Because I see here, the default time zone is SYSTEM.

andipedia

Thank you all, it has been resolved with the format:
default-time-zone=+07:00