search

prestodb / presto

The official home of the Presto distributed SQL query engine for big data
http://prestodb.io
Apache License 2.0
16.08k stars 5.39k forks source link

err : Could not create connection to database server (mysql) #24119

Open 0xpradish opened 6 days ago

0xpradish commented 6 days ago

Issue: I am setting up Presto with the MySQL connector, but I am encountering an error. I am running Presto as a Docker container and have MySQL installed locally.

My current configuration: In the mysql.properties file for Presto, I have the following settings:

properties

connector.name=mysql connection-url=jdbc:mysql://localhost:3306 connection-user=root connection-password=password

I've also tried using the host's IP address instead of localhost, but the issue persists. Can anyone help me resolve this?

agrawalreetika commented 11 hours ago

@0xpradish What MySQL & Presto version are you using? Did you check if your MySQL server is reachable from the Presto coordinator pod?

I can connect to the latest Mysql (https://hub.docker.com/_/mysql) via my lastest Presto fine.