ERROR 2059 (HY000): Authentication plugin 'mysql_native_password' cannot be loaded

ERROR 2059 (HY000): Authentication plugin 'mysql_native_password' cannot be loaded: dlopen(/opt/homebrew/Cellar/mysql/9.0.1_3/lib/plugin/mysql_native_password.so, 0x0002): tried: '/opt/homebrew/Cellar/mysql/9.0.1_3/lib/plugin/mysql_native_password.so' (no such file), '/System/Volumes/Preboot/Cryptexes/OS/opt/homebrew/Cellar/mysql/9.0.1_3/lib/plugin/mysql_native_password.so' (no such file), '/opt/homebrew/Cellar/mysql/9.0.1_3/lib/plugin/mysql_native_password.so' (no such file)

원인

local mysql version와 RDS mysql version 차이로 인한 오류 발생

local mysql version : mysql 9
RDS mysql version : mysql 8

해결 방법

local db 재설치 진행

기존 설치 삭제

brew uninstall mysql

brew로 설치 방법

brew install mysql@8.0

docker로 설치 방법

docker-compose.yml

services: 
	mysqldb:
        image: mysql:8.0
        environment:
            MYSQL_ROOT_PASSWORD: [password]
            TZ: Asia/Seoul
        volumes:
            - ./mysql/data:/var/lib/mysql
        ports:
            - 3306:3306
        platform: linux/x86_64
        healthcheck:
            test: ["CMD", "mysqladmin", "ping"]
            interval: 5s
            retries: 10

docker compose up -d