Bug #50672 add a [DEFAULT] TIMEZONE [=] time_zone option to CREATE DATABASE
Submitted: 27 Jan 2010 18:04
Reporter: Matthew Lord Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: General Severity:S4 (Feature request)
Version:5.5 OS:Any
Assigned to: Geir Høydalsvik CPU Architecture:Any
Tags: create database, time_zone, timezone

[27 Jan 2010 18:04] Matthew Lord
Description:
It would be very helpful to have different time zones for different databases.  This would be particularly helpful for hosting providers who have customers in 
different time zones while their data is in the same mysqld instance.  We could
add this support using the CREATE DATABASE statement:

CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name
    [DEFAULT] CHARACTER SET [=] charset_name
    [DEFAULT] COLLATE [=] collation_name
    [DEFAULT] TIMEZONE [=] time_zone

How to repeat:
n/a

Suggested fix:
n/a