How to change the time in MySQL server

We showed you the other day how to change the time server in Ubuntu Linux in .

But then I realised that MySQL server was not using the updated time, why was that???

Well, remember, that if you would like the change in linux time to affect MySQL server, you have to restart MySQL server

service mysql restart

and then it will use the same time as the linux server.

How to change the timezone in Ubuntu server

If you need to change the timezone of your server, just run this simple command

dpkg-reconfigure tzdata

It will guide you through a menu to select the geographical zone and the time of your preference.

More info: http://codeghar.wordpress.com/2007/12/06/manage-time-in-ubuntu-through-command-line/