Has anyone been able to use managed MySQL?
I tried to use Digital Ocean’s new managed MySQL but users I create use cachingsha2password authentication which the Node mysql client doesn’t support. DigitalOcean support told me to run
ALTER USER myuser IDENTIFIED WITH mysql_native_password BY 'mypassword';
but I got a permissions error, apparently I don’t have permission to run that on their MySQL cluster.
So, is their new managed MySQL offering 100% useless for anyone wanting to use it with Node?