Can only connect via JDBC if Workbench first
Posted by: Bassam Safar
Date: September 23, 2020 10:41AM

I installed MySQL, Workbench and ConnectorJ 8.0.21 on a virtual (EC2 on amazon) Windows Server 2016. MySQL server get installed as a Window Service and it says it is started as expected.

My problem is that I cannot connect via JDBC. However, if I first connect via Workbench AND then try the exact same JDBC again, then it magically works. If I restart the window service for the MySQL server... then Im back to square one. I either have to first connect via Workbench or via command line before being able to connect via JDBC.

My javaprogram that tries to connect via JDBC is run locally on the same machine and uses the following censored connection string:
jdbc:mysql://localhost:3306/xxx?user=yyy&password=zzz&autoReconnect=true&useSSL=false&serverTimezone=Europe/Stockholm

Options: ReplyQuote


Subject
Written By
Posted
Can only connect via JDBC if Workbench first
September 23, 2020 10:41AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.