log1
ERROR 2059 (HY000): Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/Cellar/mysql/5.7.22/lib/plugin/caching_sha2_password.so, 2): image not found
log2
0|koolog | code: 'ER_NOT_SUPPORTED_AUTH_MODE',
0|koolog | errno: 1251,
0|koolog | sqlState: '08004',
0|koolog | sqlMessage:
0|koolog | 'Client does not support authentication protocol requested by server; consider upgrading MySQL client' } }
위와같은 에러가 출력되면 workbench 에 접속해서 아래 명령어를 입력해준다.
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'