MySQL timezone change?

by

The easiest way to do this, as noted by Umar is, for example

mysql> SET GLOBAL time_zone="America/New_York";

Using the named timezone is important for timezone that has a daylights saving adjustment. However, for some linux builds you may get the following response:

#1298 – Unknown or incorrect time zone

If you’re seeing this, you may need to run a tzinfo_to_sql translation… it’s easy to do, but not obvious. From the linux command line type in:

mysql_tzinfo_to_sql /usr/share/zoneinfo/|mysql -u root mysql -p

Provide your root password (MySQL root, not Linux root) and it will load any definitions in your zoneinfo into mysql. You can then go back and run your 

mysql> SET GLOBAL time_zone = timezone;

More Related Contents:

  1. How do I set the time zone of MySQL?
  2. How do I get the current time zone of MySQL?
  3. How to store a datetime in MySQL with timezone info
  4. MySQL CONVERT_TZ()
  5. How to convert time to the time zone of the iPhone device?
  6. Can MySQL convert a stored UTC time to local timezone?
  7. MySQL Time Zones
  8. NodeJS responded MySQL timezone is different when I fetch directly from MySQL
  9. Database returned an invalid value in QuerySet.dates()
  10. Delete the entire content of all table in a Database [closed]
  11. MyISAM versus InnoDB [closed]
  12. How do I find the MySQL my.cnf location
  13. What’s faster, SELECT DISTINCT or GROUP BY in MySQL?
  14. MySQL select one column DISTINCT, with corresponding other columns
  15. How to use mysql JOIN without ON condition?
  16. How to remove all non-alpha numeric characters from a string in MySQL?
  17. Prevent auto increment on MySQL duplicate insert
  18. MySQL – force not to use cache for testing speed of query
  19. How do I know when my docker mysql container is up and mysql is ready for taking queries?
  20. How to count all rows when using SELECT with LIMIT in MySQL query?
  21. MySQL FULL JOIN?
  22. How to fix double-encoded UTF8 characters (in an utf-8 table)
  23. How to integrate ElasticSearch with MySQL?
  24. MySQL INSERT INTO … VALUES and SELECT
  25. MySQL LOAD_FILE() loads null values
  26. MySQL Select ID’s which occur on different rows with multiple specific values for a column
  27. How to sort a MYSQL table in a permanent way?
  28. Creating MYSQL Procedure in Laravel 4 Migrations
  29. MySQL: Computed Column
  30. Default sort-ordering in MySQL (ALTER TABLE … ORDER BY …;)

Leave a Comment