Has anyone been able to use managed MySQL?

I’m also having the same issue. One of the issues I’m experiencing is the requirement to specify the ssl-mode in the connection string. To be able to connect at all to the DO managed MySQL service, I have to specify ssl-mode=DISABLED.

I’ve downloaded the Cert and applied manually to my pod, but I’m still getting the caching_sha2_password error after trying the ALTER USER query.

Tongas, you might try to see if you can add the ssl-mode=DISABLED or enable SSL from your app to the managed MySQL instance?

I’m facing a similar issue with the provided primary user “doadmin” having no super privileges. Not even able to import an existing db because of this

Apparently, “root” is the only user on the cluster with any rights

Hello,

I am already using the managed MySQL services for a few of my projects.

I’ve also tested your query and I can confirm that it is working as normal and also I can confirm that the doadmin database user has privileges to run this on your MySQL cluster.

There are two things that you might want to consider:

• Create a new user with mysql_native_password, then you can use this for your projects as normal:

CREATE USER 'your_user'@'your_server_ip ' IDENTIFIED WITH mysql_native_password BY 'your_password';

• Or if you would like to keep using the doadmin user, then the query that you need to run would be:

ALTER USER doadmin IDENTIFIED WITH mysql_native_password BY 'your_new_password_here';

If you are still getting any errors feel free to share them here and I’ll be happy to advise you further.

Regards, Bobby