I've recently downloaded DataGrip to evaluate it as a potential IDE for my company. I was able to connect to our servers without any problems, but ran into trouble when connecting to localhost.
When trying to connect to localhost using the same parameters that work successfully in other SQL IDEs, I first get an error that one of my connection properties has an invalid value (this itself is strange as I received no such error when connecting to the same database hosted on our server):
Once, I resolve this issue by changing the property zeroDateTimeBehavior from ConvertToNull to CONVERT_TO_NULL the database connection simply fails to connect without any additional information provided.
Any help on how to resolve this issue would be greatly appreciated! Please let me know if there is any additional information that would be helpful.