We have a scenario that has several interactions with a MySQL database. It was working perfectly until one day it stopped. A little bit of digging later and we discover our hosts had removed external access to our databases (they said it was due to PCI compliance)… it’s left us up the creek. We need to migrate database to a new host and setup a new connection.
If anyone is using Make to connect to a MySQL database can you let me know where it is hosted? (obviously it must be accessible without SSH Tunnelling as Make does not support that)
Thanks Alex. Tried that, didn’t work… basically it is pretty much impossible to make a new database accessible without a VPS with root access.
If you have an existing connection on managed then you may be ok for a time but those connections will eventually be closed due to “PCI Compliance”
I found the solution with Digital Ocean (https://digitalocean.com/)which has a dedicated MySQL hosting option. It takes a little learning which isn’t necessarily a bad thing but once i had it figured out everything was up and running in no time.