MySQL time zone Database

Last modified by Yu Pang Law on 2022/12/14 09:58
  1. Import Time Zone Data to MySQL
    mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p mysql
  2. Grant "Select" Privileges to MySQL user
    GRANT SELECT ON mysql.time_zone_name TO cacti@localhost;
    flush privileges;

Posted by Yu Pang Law · Categories: · Permalink

Tags:
 
Copyrighted by Pangnet.net