Hello there,

newbie question here. My mySQL time is 6 hours fast, and I don't know why or how to change it. My computer is at the right time, so apparently mySQL does not get the time from it. Where do I change the time for mySQL?

Recommended Answers

All 2 Replies

MySQL uses the system time but makes adjustments for UTC. UTC (Coordinated Universal Time) is an atomic timescale that approximates UT1. It is the international standard on which civil time is based. Universal time is a timescale based on the rotation of the Earth. It is a modern continuation of Greenwich Mean Time (GMT), i.e., the mean solar time on the Prime Meridian at Greenwich, and GMT is sometimes used loosely as a synonym for UTC.

Ok, so how do I tell it to use local time?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.