(mysql.info) timezone-problems

Info Catalog

(mysql.info) problems-with-mysql-sock

(mysql.info) administration-issues

 
 A.4.6 Time Zone Problems
 ------------------------
 
 If you have a problem with `SELECT NOW()' returning values in UTC and
 not your local time, you have to tell the server your current time
 zone. The same applies if `UNIX_TIMESTAMP()' returns the wrong value.
 This should be done for the environment in which the server runs; for
 example, in `mysqld_safe' or `mysql.server'. See 
 environment-variables.
 
 You can set the time zone for the server with the
 -timezone=TIMEZONE_NAME option to `mysqld_safe'. You can also set it by
 setting the `TZ' environment variable before you start `mysqld'.
 
 The allowable values for -timezone or `TZ' are system-dependent.
 Consult your operating system documentation to see what values are
 acceptable.
 

Info Catalog

(mysql.info) problems-with-mysql-sock

(mysql.info) administration-issues