Change Server Timezone

Hello Helical,

I am using Helical Insight 4.0 and getting the following error when trying to create a connection. Can you let me know what this error means and how it can be rectified? I am working in multiple timezones and using MySQL database.

image

Thanks,
Netta

Hello netta,

The above error is occurring due to different time zones on the server and database. For this, find the MySQL configuration file named my.ini or my.cnf on the db server.

Add the default timezone at the end of the file as shown below:

image
Now you will be able to make the connection properly from the datasources page.