Connecting to MySQL server in production.
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:
However, in localhost, it connects to the database perfectly. The environment variables are exactly the same.
3 Replies
Hi @lilnasbooty43
This is a known issue. One suggestion is that you should consider using
caching_sha2_password as authentication plugin instead of sha256_password as it is preferred because of superior security and performance.
https://github.com/prisma/prisma/issues/14417#issuecomment-1269444919GitHub
MySQL: add support for
sha256_password authentication plugin · Is...Discussed in #14181 Originally posted by ansarizeeshan July 5, 2022 Bug description I am trying to connect to MySQL data : 5.7.33 and it is failing with below error.: Environment variables loaded f...
The site I have my database on does not allow access to my.cnf nor alter user
and why does it work on localhost but not the site host?
Can you use MySQL 8.0? I believe this issue occurs only in older versions of MySQL