Can only connect via JDBC if Workbench first
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
Subject
Written By
Posted
Can only connect via JDBC if Workbench first
September 23, 2020 10:41AM
September 25, 2020 06:28AM
September 30, 2020 05:32AM
Sorry, you can't reply to this topic. It has been closed.
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.