Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2011
    Posts
    2

    Unanswered: Mysql Local Date

    MySQL will be run on a local server (a PC) and there may be times when a user might not know that the machine date had been accidentally changed, so the insertion date can be future or past . Is there any ways to solve this problem..

  2. #2
    Join Date
    Sep 2009
    Location
    San Sebastian, Spain
    Posts
    880
    The server should not allow the times to change and times should be kept in sync with a time server client (on Linux ntp service). You should disable allowing anyone to modify the date/time on the server.
    Ronan Cashell
    Certified Oracle DBA/Certified MySQL Expert (DBA & Cluster DBA)
    http://www.it-iss.com
    Follow me on Twitter

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •