Linux PHP MySQL time zone settings

In the LAMP environment, it is ideal that the time zones of Linux PHP MySQL are set to the same. Otherwise, the program will easily encounter time difference problems. Assume that the time zone is set to "Asia/Shanghai"

1. Set the time zone in Linux. Take CentOS5.5 as an example:

Cp-f/usr/share/zoneinfo/Asia/Shanghai/etc/localtime

2. Set the time zone in MySQL

Edit the MySQL configuration file: my. cnf/my. ini, and add:

Default-time-zone = '+ 8:00'

In fact, if the OS time zone of MySQL is set correctly, you do not need to set the time zone in MySQL because the OS time zone is automatically used when the MySQL service is started.

3. Set the time zone in PHP

In the PHP configuration file PHP. ini:

 

1 date. timezone = "Asia/Shanghai"

After setting, you are advised to restart the system.

If you have purchased a Web space, you are not authorized to configure the time zone in Linux PHP MySQL. In this case, you only need to set the time zone corresponding to the OS in the PHP script, because MySQL uses the OS time zone by default. If the OS time zone is 'Asia/Shanghai', use one of the following two statements:

Ini_set ('date. timezone ', 'Asia/Shanghai ');

Date_default_timezone_set ('Asia/Shanghai ');