Join 1M+ other developers and:
- Get help and share knowledge in Q&A
- Subscribe to topics of interest
- Get courses & tools that help you grow as a developer or small business owner
MySql Connection from DO droplet to MySql cluster
I’m running node.js application from DO droplet the app is running fine, however, it does not connect to MySql DB on DO cluster. The connection works fine from my local machine to the cluster (I’m using the same credentials for the db connection), Workbench connecting without a problem too.
Here is the error: ERNOTSUPPORTEDAUTHMODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
Following this guide: https://docs.digitalocean.com/products/databases/mysql/resources/troubleshoot-connections/ I have changed the plugin to ‘mysqlnativepassword’ using - ALTER USER 'USERNAME’@’%'IDENTIFIED WITH mysqlnativepassword BY 'PASSWORD’. The user has all the privileges. That helped to connect to the DB from the app that is running on my local machine. Nothing changed for the app that is running on the droplet it still does not communicate with the DB on the Cluster.
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.×