Has anyone tried to connect an appsheet data spurce with mysql aiveen?
Hey Hugo,
You might want to review the AppSheet documentation for detailed instructions, but here’s a quick guide to help you get started:
-
Open the AppSheet Editor and navigate to Data > Tables.
-
Click Add Table and select Cloud Database.
-
From the dropdown menu, choose MySQL as your data source.
-
Enter your Aiven MySQL connection details: Host, Port, Database Name, Username, and Password.
-
Click Test Connection to ensure that AppSheet can successfully access your database.
If you run into any issues, double-check that you can connect to your Aiven MySQL in general. You might also need to adjust your firewall settings or user permissions to allow remote access.
Heres a list of different ways of Connect to your Aiven for MySQL® service
The quick connect guide within your service has many of these options as well
Hope this helps! Take care.
Thank you Hugo for your patience!
I was able to duplicate the issue and find that the missing piece is, more than likely, the port number at the end of the server. It’s not something that is clearly stated anywhere in the AppSheet documentation 
Example: mysql-2f592b6b-testproject-siou-john-doe-test.avns.net:23318
The port number is listed where you find the Connection Information.
