Hello. I installed and deployed a local version of retool as described here: Trialing Retool locally
And I'm running a MySQL server on my Ubuntu machine. When I try to connect retool to my database in the "Configure MySQL" page, I enter:
host: localhost
port: 3306 (this is the correct port)
database username: root
database password: [correct password for root]
And I get the error: Unable to connect. Error: connect ECONNREFUSED 127.0.0.1:3306
This is true whether I use SSL connection or not. I also get the same error if I change the port to something wrong like 3308. I've checked the mysql error logs and don't see anything about a failed login attempt, which I DO see if I simply try to start the mysql client with an incorrect password (so I know some logging is happening).
Oh, last detail - if I use the host "host.docker.internal" as suggested in the UI, I get the error "Unable to connect. Error: getaddrinfo ENOTFOUND host.docker.internal"
I'm a beginner with both MySQL and retool, so I'm at a loss as to what to do. Any help would be massively appreciated!