[Mysql + PHP] Mysql8.* caching_sha2_password 문제

/etc/mysql/my.cnf 파일에 아래 문구 추가

default-authentication-plugin=mysql_native_password

 

https://stackoverflow.com/questions/50026939/php-mysqli-connect-authentication-method-unknown-to-the-client-caching-sha2-pa

php mysqli_connect: authentication method unknown to the client [caching_sha2_password]

https://mysqlserverteam.com/upgrading-to-mysql-8-0-default-authentication-plugin-considerations/