The official MySQL Driver cannot connect to MySQL databases of other versions about presto HOT 7 CLOSED

Ah I see! I didn't catch that you were using the helm chart earlier. The mysql properties definitely look sound. I tried it out with the latest version of MySQL and didn't run into this issue, but can reproduce using version 5.7.40, like you said! Based on my research, I think the driver v5.1.48 and MySQL v5.7.40 disagree on security protocols. For compatibility reasons the driver doesn't enable TLSv1.2 and higher by default. A workaround here would be to add the below option to your mysql connection string in the properties:

connection-url=jdbc:mysql://X.X.X.X:3306?enabledTLSProtocols=TLSv1.2&serverTimezone=UTC

Hopefully that does the trick!

from presto.

Thanks for your help! I successfully solved the trick when I added the configuration. ^_^

from presto.

If I want to use MYSQL database version 5.7 is there any way to solve this problem?

from presto.

Hi @clown-k - I have a few follow-up questions for you! Are you submitting your query using the presto CLI? Also, just to clarify, you mention a MySQL version of 5.7 - is that the version of your actual MySQL database? If the answer to both of these is yes, we should probably take a look at your mysql.properties file to see what the error might be

from presto.

Hi @kiersten-stokes - I created mysql.properties using values.yaml of the official Chart.

#Catalogs
catalog: 
  mysql: |-
    connector.name=mysql
    connection-url=jdbc:mysql://X.X.X.X:3306?serverTimezone=UTC
    connection-user=X
    connection-password=X

The configuration file actually generated in Pod:

$ cat /opt/presto-server/etc/catalog/mysql.properties
    connector.name=mysql
    connection-url=jdbc:mysql://X.X.X.X:3306?serverTimezone=UTC
    connection-user=X
    connection-password=X

from presto.

I don't think mysql.propertiesis erroneous. Because mysql-connector-java-5.1.48.jar is used in /opt/presto-server/plugin/mysql/, and when I use version 5.1.48 of MYSQL database(not on the k8s), it works.

from presto.

@clown-k glad to hear it!

from presto.