I am using the following to connect to an external database and the connection is successful when I don’t select a DB Type. It is unsuccessful when I actually select MySQL Is this okay when I actually go to make queries?
mysql://user:pass@IP:PORT/database_name
Because it brings me to my second question…
2) When I add a query and select the connection string, I get the response that there was an issue with the plugin.
My query works when I run it directly on the database and returns the correct results; however, when I run it in Bubble it it gives me an error. Note: I followed your instructions when using SELECT to limit the number of rows so LIMIT 100 is added to the end of the query.