mysql timezone

Discussion in 'ISPConfig 3 Priority Support' started by molahs, Mar 25, 2019.

  1. molahs

    molahs Member HowtoForge Supporter

    On the ubuntu 18 with nginx & ispconfig3 virtual machine, the time in mysql is one hour out.
    I read only this needs to be change in my.cnf, but i can't find any configuration file that mentions the default-time-zone
    in /etc/mysql/

    Where would i make this change?

    when I run the following two queries in mysql (Mariadb actually) i get SYSTEM
    SELECT @@global.time_zone;
    SELECT @@session.time_zone;

    Thanks
     
    molahs, Mar 25, 2019
    #1
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    And the system time is correct when you run the command:

    date

    on the shell?
     
    till, Mar 25, 2019
    #2
  3. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    Mariadb should follow the system timezone, so check what shows
    Code:
    cat /etc/timezone
    At least on Debian that works, if Ubuntu is different check Ubuntu timezone documentation.
    On a virtual machine, what is time, date and timezone on the host computer?
     
    Taleman, Mar 25, 2019
    #3

Share This Page