Override Configuration file mysql

[Zippo]

In the manual of MySql it says that you can make an override for the default configuration of mysql.

Because a lot of my users live in a different timezone than the mysql server I want to override this variable.

The manual states it will look in the /etc/ dir for a my.cnf
I made such a file (uploaded it in ASCII) with the folliwing contents
------------------
[mysqld]
timezone=GMT+1
------------------

It does not seem to work... what am I doing wrong?

Zippo

[James]

Your etc directory is not the system directory. The mysql server reads its conf file from the system's /etc directory. Per database overides is not something that mysql supports, so we can not change the time zone for just your mysql database.

[Zippo]

Thank you for the reply,

I will have to figure out another way then.

Grtz. Peter