Hosted by DreamHost, my MySQL server in phpmyadmin cannot be connected by my NextJS application on DigitalOcean's app platform. I am faced with this error:
Error querying the database: Unknown authentication plugin `sha256_password'.
Error querying the database: Unknown authentication plugin `sha256_password'.
However, in localhost, it connects to the database perfectly. The environment variables are exactly the same.