List:General Discussion« Previous MessageNext Message »
From:Dominik Klein Date:March 27 2006 7:31am
Subject:Re: mysqld_safe and timezone settings
View as plain text  
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
Thread
mysqld_safe and timezone settingsMichael Sutter23 Mar
  • Re: mysqld_safe and timezone settingsDominik Klein24 Mar
  • Re: mysqld_safe and timezone settingsDominik Klein27 Mar
    • Re: mysqld_safe and timezone settingsMichael Sutter27 Mar
Re: mysqld_safe and timezone settingsMichael Sutter25 Mar