Tag: php

  • Set Timezone for MYSQL / PHP

    After setting system time, I discovered that mysql and php services didn’t also update the timezone settings. Here’s how to make sure they also reflect the correct timezone.

    First locate all the php.ini files in /etc

    cd /etc/
    find . | grep php.ini
    ./php/7.4/apache2/php.ini
    ./php/7.4/cli/php.ini

    now edit these files and add the timezone info

    nano ./php/7.4/apache2/php.ini

    add this to the [Date] block:

    [Date]
    date.timezone = "America/New_York"

    For mysqld portion, first copy timezone data into mysql tables:

    mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql
    

    Now edit the mysqld.cnf file:

    nano /etc/mysql/mysql.conf.d/mysqld.cnf

    And add this to the [mysqld] block:

    [mysqld]
    default-time-zone='America/New_York'
    

    Finally do a service restart:

    systemctl restart mysql
    systemctl restart apache2

    That’s It, Enjoy!