I am attempting to make a direct connection to an exisitng MySQL database on my own PC. The error ‘Driver com.mysql.jdbc.Driver could not be loaded’ occurs after I have supplied the password for the SQL server.
I am using Windows 10 professional 64 bit
LO 6.2.8.2 64 bit
MySQL (community) 8.0.18 This works OK.
Java 8 update 231 64 bit Java works fine within the LO base help system.
Any ideas which could lead to a solution will be greatly appreciated.
Chris
Sorted it but don’t know why I neede to do this. As a test I decided to set up an ODBC connection, fine. I then tried Java, this failed with the same error. After much trawling arounf the internet I found and downloaded from Oracle a .zip file containing, amongst other things, msql-connector-java-8.0.19.jar. In LO tools → options → advanced a screen with Java Options ticked and the name of my current jre appears. On this screen click ‘Add Path’ then navigate to or create C:\ProgramFiles\MySQL\Connector.J.8.0.19 and put the .jar files in it. Click OK a few times.
A Java connection now works. Returning to the direct connection this also works.
Remaining question: Why does a direct connection require the Java connector?