How to Change the MySQL Time Zone

Skip ad
11 Views

  • Thanks! Share it with your friends!

    You disliked this video. Thanks for the feedback!

Inmotionhosting
Published
Learn how to change your server’s MySQL Time Zone via SSH access. First, we’ll show you how to view your current MySQL time zone setting, which is usually set to use the same time as your server. Then we’ll walk you through changing the time zone setting and viewing it again to verify the change.
00:00 Intro
00:32 View MySQL Time Zone Setting
00:55 View Server’s Time Stamp
01:07 View MySQL Server’s Time Stamp
01:18 Change Time Zone Setting
01:58 Restart MySQL Service
02:09 View Updated MySQL Time Zone Setting
02:20 View Updated MySQL Server’s Time Stamp
02:35 Outro

Commands used in this video:
►View Global Time Zone setting: mysql -e "SELECT @@global.time_zone;"
►View Current Server Time: date
►View Reported MySQL Server Time: mysql -e "SELECT NOW();"
►Edit my.cnf File: nano /etc/my.cnf
►Set the Default Time Zone: default-time-zone = '-05:00'
►Restart MySQL: service mysql restart

To learn more see our full guide on How to Change Your Server’s MySQL Time Zone:
► https://www.inmotionhosting.com/support/server/databases/how-to-change-mysql-server-time-zone/

You can also find out more by going to our Working with Databases section:
► https://www.inmotionhosting.com/support/server/databases/

Related Guides:
How to Set the Server Time Zone in WHM:
► https://www.inmotionhosting.com/support/edu/whm/setting-the-server-time-zone-in-whm/

About Us:
InMotion Hosting was founded in 2001 and provides personal and business web hosting for everyone! For more information about our scalable unmanaged VPS plans, visit us at
► https://www.inmotionhosting.com/cloud-vps

#MySQL #Database #MySQLTimeZone #DatabaseAdmin #DatabaseManagement #DBAdmin #DBManagement
Category
InMotion Hosting
Tags
MySQL, Database, MySQLTimeZone
Be the first to comment