Wiranata Posted January 16, 2013 Share Posted January 16, 2013 how to configuration time zone in mysql web server?? i have web server idhostinger Quote Link to comment Share on other sites More sharing options...
trq Posted January 17, 2013 Share Posted January 17, 2013 Your going to need to clarify your issue. Mysql is a *database* server. Quote Link to comment Share on other sites More sharing options...
Wiranata Posted January 17, 2013 Author Share Posted January 17, 2013 Your going to need to clarify your issue. Mysql is a *database* server. Your going to need to clarify your issue. Mysql is a *database* server. how can i do this?? in localhost i succesfully about this,but when i upload form with timezone...timezone is wrong Quote Link to comment Share on other sites More sharing options...
jazzman1 Posted January 19, 2013 Share Posted January 19, 2013 When MySQL has been started, by default it takes the time zone of the local machine(server). If you are using shared hosting server, you don't have permissions to change a global time zone on the server and the database. By default each client that connects has its own time zone setting, given by the session time_zone variable in MySQL. You can change your own time_zone using the sql SET statement. For example: SET time_zone = 'America/Toronto' or SET time_zone = '+07:00' or ALTER DATABASE <database_name> SET time_zone = 'America/Toronto' Take a look at here to obtain much more details about this. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.