I am attempting to connect to a local PrestoDB db using DataGrip but having some troubles.
My PrestoDB instance does not require a password but no matter what I do, DataGrip prompts for credentials.
- Downloaded the presto JDBC driver: presto-jdbc-329.jar
- Created a new driver in DataGrip using this file
- Created a new data source using this driver and URL of: jdbc:presto://localhost:8080?user=ivan
Is there a problem connecting to databases that do not require a password? If I add a blank password, I get the error:
'Authentication using username/password requires SSL to be enabled'
Also I have tried using the same driver in a simple java class and it works fine, connecting to the same presto instance.