Issue
I am having trouble connecting to my MySQL database from Appsmith running in a Docker container on my Ubuntu 20.04 machine. I have provided all the necessary permissions to the database user and added the correct IP address and port number to the datasource configuration, but I keep getting a timeout error. I tried using "db" as the Host Address value, but that didn't work either. When I accessed the IP address and port number via the browser, I got an error message. I am looking for a solution to this problem.
Resolution
When running Appsmith and MySQL in separate Docker containers on Ubuntu, you need to ensure proper networking so the Appsmith app can communicate with your database.
For most local setups, you can configure the datasource by using `host.docker.internal` (or the container name on Linux) as the host address.
For detailed steps, refer to the official Appsmith guide: How to Work with Local Datasources on Appsmith