How to change mysql time zone Edit /etc/my.cnf and change your time zone. root@box1 [/var/lib/mysql]# cat /etc/my.cnf [mysqld_safe] timezone = Europe/London ~ [mysqld] set-variable = max_connections=500 safe-show-database Login to mysql and check the time now. root@box1 [/var/lib/mysql]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 369 [...]
-
Blog Home
Blogroll
Quick Links
Navigation
Archives
-
Recent Posts
Calendar
Cloud
alert apache backup centos chrome configuration database deviccs DMA DNS example filesystem fsck google harddisk IDE java kernel LAMP linux mail Mode MTU mysql nagios network old OpenDNS openvz password PECL performace permission php redhat repository root Rsync SATA server setup timezone ubuntu user virtualization