I have upgraded mysql (8.0.12) in my Mac machine. After upgrading mysql Laravel, drupal projects mysql connection not working even sequel pro also not connected to mysql.
I have tried with raw PHP and it showing following message:
mysqli_connect(): The server requested authentication method unknown to the client [caching_sha2_password]
In Laravel Project it is showing:
SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client
I got couple of solution from SO but it doesn't work. I am looking for a solution.