Linux PHP MySQL time zone settings

Source: Internet
Author: User
Tags time zones php mysql

This article describes how to set the time zone of Linux PHP MySQL. I hope this method will be helpful to you.

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 ');

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.