I am using Laravel 7 to do testing on DigitalOcean’s managed database cluster. Laravel connection doesn’t work, with error and I have fo find the fix that causing it.
Illuminate\Database\QueryException SQLSTATE[HY000]  The server requested authentication method unknown to the client
This issue has been fixed in PHP7.4, please install PHP7.4 in the Droplet. If you are running on NGINX:
## install php7.4 fpm $ sudo apt install php7.4 php7.4-fpm ## install php7.4 mysql $ apt-get install php7.4-mysql
After that, update the NGINX sites configuration to the correct PHP-FPM version.
This should allow you to connect your Laravel 7 application to Digital Ocean’s managed database MySQL version 8.
This post may not 100% fix your situation, hope to bring some idea to this MySQL 8 issue in the managed database.
Few points to note :