How do I set the time zone of MySQL?

On one server, when I run:

mysql> select now();
+---------------------+
| now()               |
+---------------------+
| 2009-05-30 16:54:29 |
+---------------------+
1 row in set (0.00 sec)

On another server:

mysql> select now();
+---------------------+
| now()               |
+---------------------+
| 2009-05-30 20:01:43 |
+---------------------+
1 row in set (0.00 sec)

Related Posts:

  1. Mapping US zip code to time zone
  2. How to initialize a JavaScript Date to a particular time zone
  3. Getting the client’s time zone (and offset) in JavaScript
  4. MySQL Error “Operand should contain 1 column”
  5. How to use MySQL DECIMAL?
  6. MySQL server startup error ‘The server quit without updating PID file’
  7. Invalid column count in CSV input on line 1 Error
  8. Setting up foreign keys in phpMyAdmin?
  9. Python: tuple indices must be integers, not str when selecting from mysql table
  10. MySQL error code: 1175 during UPDATE in MySQL Workbench
  11. Access denied; you need (at least one of) the SUPER privilege(s) for this operation
  12. MySQL Server on MAMP-Windows Will Not Start
  13. SQL statement not working – “Operand type clash: date is incompatible with int’
  14. MySQL starts with searching issue
  15. importing a CSV into phpmyadmin
  16. How can I rebuild indexes and update stats in MySQL innoDB?
  17. select * from table where column = something or, when unavailable, column = something else
  18. Differences between utf8 and latin1
  19. There can be only one auto column
  20. Convert UTC date time to local date time
  21. What’s a good strategy for planning WordPress DB growth?
  22. simple sql query on wp_postmeta very slow
  23. How to get the list of WooCommerce product image of a certain category from database?
  24. tag search using WP_Query
  25. SQL query to delete comments older than 90 days?
  26. Regex to turn embedded images in to attachments
  27. How can I SQL update a meta_value to remove the dollar signs that were entered with the value? (so just the value remains)
  28. Error establishing a database connection – with Debug Data
  29. Database with mixed collation (utf8mb4 & utf8_general_ci)
  30. Grouping related postmeta data via SQL query
  31. Manually query posts by taxonomy with MySQL
  32. How can I make wordpress suppress mysql errors?
  33. How to bulk delete all WordPress subscribers?
  34. Adding new row to wp_post table
  35. How to convert objects into arrays
  36. Changing Table Prefix for an Existing WordPresss Site
  37. How to determine what is generating large amount of database queries?
  38. Get post by ASC from custome field DATE picker
  39. Set meta_key and meta_value for all registered user in wordpress using sql query [closed]
  40. How do I get the posts within a certain year/date(with sql query)?
  41. Performance when getting post meta for post retrieved by meta value
  42. Can’t get wp_insert_post to work
  43. Connect another DB and fetch records from some tables
  44. Delete all one-word comments
  45. PHP Fatal error: Uncaught mysqli_sql_exception: Table doesn’t exist in wordpress/wp-includes/wp-db.php
  46. Alter query with posts_clauses to retrieve NULL values last
  47. How to select from two different tables to display orders list with custom column from other table
  48. Error: MySQL shutdown unexpectedly [closed]
  49. Enabling WP_USE_EXT_MYSQL to support old plugin
  50. Cleaning up bloated wp_postmeta table by removing multiple _thumbnail_id’s?
  51. Connect to MySQL using Windows Authentication
  52. pagination on data fetched using SQL query
  53. create new users in db starting at what ID?
  54. Delete post results in “Cannot delete or update a parent row: a foreign key constraint fails”
  55. Using ‘mysqli_connect’ ‘crashes’ WordPress client-side
  56. Importing WordPress Posts With Custom Meta Data As CSV Files Through PHPMyAdmin
  57. email alert for product availability
  58. how to insert missing tags into the posts through mySQL?
  59. How to set MYSQLI_OPT_INT_AND_FLOAT_NATIVE option
  60. How do I prepare strings for insertions as values into a MySQL table?
  61. How can I detect right db type?
  62. How to insert dash (-) into database using wpdb and new_to_publish hook?
  63. MySQL: How to change url in posts from xxx.com to yyy.org?
  64. Second ezSQL initialization for MSSQL
  65. WordPress & MySQL , problem with use many array in meta_query
  66. WordPress paginate_links function: How do i ensure the page number is not less than 1 and not greater than last
  67. WordPress low speed after migrating to new host
  68. JOIN and SUM different statement results (Mailster Database)
  69. How to escape percentage sign(%) in sql query with $wpdb->prepare?
  70. Get All Results From Other Users That Share The Same Custom User Meta As Current User
  71. call to undefined function mysql_connect
  72. Recovery – Restore Database after moving folder location locally
  73. Performing CRUD operations on front end in wordpress
  74. Deleted products from woocommerce are still in the database
  75. WordPress cloning issue
  76. How to edit content in WordPress and the Polylang – plugin? – with demosite
  77. WordPress Dutch characters encoding problem
  78. Case insensitive ORDERBY in wpquery
  79. Search returns “Nothing Found” on a sub directory
  80. Update a user meta key based on WooCommerce product purchase
  81. Add postmeta to all blog posts
  82. How do I insert content of various MySQL fields in post?
  83. HyperDB failover Delay
  84. Select latest 2 articles, but only from given category
  85. Error while submitting form using AJAX and php
  86. CONCAT_WS in custom sql query
  87. Ordering topics by most replies in X days using MYSQL statement
  88. WordPress upload images not displaying
  89. Slow WordPress admin panel with a total query time of 1664ms
  90. MySQL database migration to WordPress
  91. Running WordPress from MySQL Cluster with HAPRoxy
  92. Query Concatenation
  93. cannot log in to the mysql server (wamp and wordpress)
  94. SQL command to export post_content from wp_posts using phpMyAdmin
  95. Display total count of products in orders of a specific order status
  96. SQL query into to WP query
  97. Assign a tag to custom post type using a query
  98. Getting 504 Gateway Timeout Error on AWS Server! [closed]
  99. WordPress issue – data is not showing in wp-admin, but when searching through database, all the data is there
  100. How to find fresh (last modified) and sql backup?

Leave a Comment