Linux PHP MySQL Time Zone synchronization settings

In the LAMP environment for Linux PHP MySQL Time Zone synchronization, the ideal situation is that the time zones of Linux PHP MySQL are set to the same, otherwise the program is prone to time difference problems. Assume that the time zone is set to "Asia/Shanghai" www.2cto.com 1. Set the time zone in Linux. Take CentOS5.5 as an example:
1 cp-f/usr/share/zoneinfo/Asia/Shanghai/etc/localtime 2. set the time zone in MySQL to edit the MySQL configuration file: my. cnf/my. ini, add: 1 default-time-zone = '+' under [mysqld'
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 configuration file PHP. in ini: www.2cto.com 1 <span style = "font-family: 'Microsoft yahei', Arial, Helvetica ';"> date. after setting timezone = "Asia/Shanghai" </span>, 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: 1 ini_set ('date. timezone ', 'Asia/Shanghai'); www.2cto. com2 date_default_timezone_set ('Asia/Shanghai'); Author: PHPUI