This was done as root and shows that TZ works.
dk:/usr/local/mysql # bin/mysql -V
bin/mysql Ver 14.12 Distrib 5.0.18, for pc-linux-gnu (i686) using
readline 5.0
dk:/usr/local/mysql # echo $TZ
dk:/usr/local/mysql # bin/mysqld_safe --user=mysql &
[1] 802
dk:/usr/local/mysql # Starting mysqld daemon with databases from
/usr/local/mysql/data
dk:/usr/local/mysql # bin/mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.0.18-standard-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> select now();
+---------------------+
| now() |
+---------------------+
| 2006-03-27 09:26:35 |
+---------------------+
1 row in set (0.05 sec)
mysql> Bye
dk:/usr/local/mysql # support-files/mysql.server stop
Shutting down MySQL...STOPPING server from pid file
/usr/local/mysql/data/dk.pid
060327 09:26:45 mysqld ended
done
[1]+ Done bin/mysqld_safe --user=mysql
dk:/usr/local/mysql # export TZ="America/Argentina/Mendoza"
dk:/usr/local/mysql # bin/mysqld_safe --user=mysql &
[1] 889
dk:/usr/local/mysql # Starting mysqld daemon with databases from
/usr/local/mysql/data
dk:/usr/local/mysql # bin/mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.0.18-standard-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> select now();
+---------------------+
| now() |
+---------------------+
| 2006-03-27 04:27:09 |
+---------------------+
1 row in set (0.00 sec)
mysql> Bye
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
