0

Via SSH I print the current date of my server, which is correct based on my location:

SSH

When I run SHOW GLOBAL VARIABLES on MySQL, I have time_zone = SYSTEM - which makes me think MySQL will be using the system date and time.

However, when I run SELECT CURRENT_TIME it returns to me a result that looks like it's in another time zone (ignore the diff in minutes due to the time I took between both snapshots):

SQL

Is there any other necessary configuration to make CURRENT_TIME in MySQL reflect exactly the same system date time?

6
  • Run these statements please: SELECT NOW(); and SHOW VARIABLES LIKE 'time_zone' to see you session's variable value. Commented Feb 15, 2018 at 20:47
  • @JehadKeriaki, SELECT NOW(); returned the time four hours less than the System hour and SHOW VARIABLES LIKE 'time_zone' returned SYSTEM Commented Feb 16, 2018 at 10:14
  • `SHOW VARIABLES LIKE '%zone%';
    – Rick James
    Commented Feb 20, 2018 at 3:01
  • @RickJames, thanks, man! system_time_zone shows CST while it should be GMT-3 (my timezone). Now it's a matter of how to change it. Commented Feb 20, 2018 at 19:31
  • @AdrianoCastro - That's an Operating System question.
    – Rick James
    Commented Feb 20, 2018 at 21:41

1 Answer 1

0

Solved, not through MySQL, but in my WHM > Server Configuration > Server Time, then clicked on Sync Time with Time Server.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.