Scale up as you grow — whether you're running one virtual machine or ten thousand.

From GPU-powered inference and Kubernetes to managed databases and storage, get everything you need to build, scale, and deploy intelligent applications.

Hi,
I have phpmyadmin installed on a droplet (not in same VPC), which I’m trying to setup to connect to the DB cluster which I have created. The server is allowed to connect, and I’m using MySQL 5.x legacy connection for the user I’m trying to connect with.
It works great to connect from the server it self, but its refusing from phpmyadmin. The error I’m getting is: The server requested authentication method unknown to the client [caching_sha2_password]
Despite that I have set for that user to use legacy MySQL 5.x, it still somehow throwing MySQL 8.x error because caching_sha2_password is used there.
I have also tried with: alter user ‘nookie’@‘%’ identified with mysql_native_password by ‘mypassword’; however I’m still getting this error.
So the question why is this not being picked up by the cluster, that i’m trying to connect with phpmyadmin from a remote server to MySQL 5 legacy connection. Is there any other settings that I can make?
hbarnard
keneucker
keneucker
rich
santoshpatil
Aspiresoftserv
Yakin
Thejaswini-Rao-U
775c69c916d345a7a367d867078ccb
mayricoak
ndam
bc2f52583874402a988f587c00195d