This article will introduce to you the detailed explanation of the Linux PHP MySQL time zone setting method. I hope this method will be helpful to you.
In the LAMP environment, the ideal situation is that the time zones of Linux, PHP, and MySQL are all set to be consistent. Otherwise, the program is prone to some unexpected [time difference] problems. Assume that the time zone is set to: "Asia/Shanghai"
1. Set the time zone on Linux, taking CentOS5.5 as an example:
cp -f /usr/share/zoneinfo/Asia/Shanghai /etc/localtime
2. Set time zone in MySQL
Edit the MySQL configuration file: my.cnf/my.ini, add:
under [mysqld]default-time-zone = '+8:00'
In fact, if the time zone of the OS where MySQL is located has been set correctly, you do not need to set the time zone in MySQL, because when the MySQL service starts, it will automatically adopt the time zone of the OS.
3. Set time zone in PHP
In the PHP configuration file PHP.ini:
1 date.timezone = "Asia/Shanghai"
After setting up, it is best to restart the system.
If you purchased the web space, you do not have permission to configure the time zone in Linux PHP MySQL. That's easy to do, you just need to set the time zone corresponding to the OS in the PHP script, because MySQL uses the OS time zone by default. Assuming that the time zone of the OS is 'Asia/Shanghai', use one of the following two statements:
ini_set('date.timezone', 'Asia/Shanghai');
date_default_timezone_set('Asia/Shanghai');