I’m trying to use the new MySQL connector but am struggling to get it to work.
For the URL endpoint I put 173.236.29.190:3306, then the database, user and password. I know the IP and port work as I have successfully connected to the database using Skyvia and that access. I have set up your IP addresses on the whitelist in the Remote mySQL application in cPanel. When I enter the information in the connector and press on the “Test Connection” button, the system waits about 5 seconds then gives me no response, not “connection failed” or “connection succeeded” response.
When I press on Save Connection, the system grays the screen and gives a message that it is saving the connection, but then nothing happens. It stays gray forever. When I click on the back button, it warns that nothing is saved and I might lose my information … and sure enough, nothing is saved.
I realize this connector is relatively new, but if you could build documentation for how to use connectors, it would be greatly appreciated. This has proven to be a significant trial-and-error (mostly error) exercise.