mysql_tzinfo_to_sql — Load the Time Zone Tables The path to the directory that  mysql_ssl_rsa_setup  should check for default SSL and RSA files and in which it should create files if they are missing. The default is the compiled-in data directory. The suffix for the Common Name attribute in X.509 certificates. The suffix value is limited to 17 characters. The default is based on the MySQL version number. The name of the user who should be the owner of any created files. The value is a user name, not a numeric user ID. In the absence of this option, files created by  mysql_ssl_rsa_setup  are owned by the user who executes it. This option is valid only if you execute the program as  root  on a system that supports the  chown()  system call. Verbose mode. Produce more output about what the program does. For example, the program shows the  openssl  commands it runs, and produces output to indicate whether it skips SSL or RSA file creation because some default file already exists. Display version information and exit. The  mysql_tzinfo_to_sql  program loads the time zone tables in the  mysql  database. It is used on systems that have a  zoneinfo  database (the set of files describing time zones). Examples of such systems are Linux, FreeBSD, Solaris, and macOS. One likely location for these files is the  /usr/share/ zoneinfo  directory ( /usr/share/lib/zoneinfo  on Solaris). If your system does not have a zoneinfo database, you can use the downloadable package described in Section 5.1.15, “MySQL Server Time Zone Support” . mysql_tzinfo_to_sql  can be invoked several ways: mysql_tzinfo_to_sql  tz_dir mysql_tzinfo_to_sql  tz_file tz_name mysql_tzinfo_to_sql --leap  tz_file For the first invocation syntax, pass the zoneinfo directory path name to  mysql_tzinfo_to_sql  and send the output into the  mysql  program. For example: mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql mysql_tzinfo_to_sql  reads your system’s time zone files and generates SQL statements from them. mysql  processes those statements to load the time zone tables. The second syntax causes  mysql_tzinfo_to_sql  to load a single time zone file  tz_file  that corresponds to a time zone name  tz_name : mysql_tzinfo_to_sql  tz_file tz_name  | mysql -u root mysql If your time zone needs to account for leap seconds, invoke  mysql_tzinfo_to_sql  using the third syntax, which initializes the leap second information.  tz_file  is the name of your time zone file: mysql_tzinfo_to_sql --leap  tz_file  | mysql -u root mysql 403 • --datadir= dir_name • --suffix= str • --uid=name ,  -v • --verbose ,  -v • --version ,  -V 4.4.4 mysql_tzinfo_to_sql — Load the Time Zone Tables