koo6357/mysql-error.md

## mysql-error.md

      
    Raw
  

              mysql-error.md
            
          
    mysql error

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'