Sequel pro Authentication plugin 'caching_sha2_password' cannot be loaded

socket 접속 불가능

• 에러 메시지

💡 Unable to connect to host 127.0.0.1, or the request timed out.

Be sure that the address is correct and that you have the necessary privileges, or try increasing the connection timeout (currently 10 seconds).

MySQL said: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so, 0x0002): tried: '/usr/local/mysql/lib/plugin/caching_sha2_password.so' (no such file), '/System/Volumes/Preboot/Cryptexes/OS/usr/local/mysql/lib/plugin/caching_sha2_password.so' (no such file), '/usr/local/mysql/lib/plugin/caching_sha2_password.so' (no such file)

• 해결

💡 `ALTER USER 'yourusername'@'localhost' IDENTIFIED WITH mysql_native_password BY 'youpassword';`

위 명령어를 mysql에서 실행 해주었더니 소켓을 통한 접속이 잘 되었다.