Mac DBeaver MariaDB dump 시 Local client is not specified for connection. 에러 해결 방법

Mac DBeaver MariaDB dump 시 Local client is not specified for connection. 에러 해결 방법

- mysql 클라이언트 혹은 mysql 서버를 깔아야 함

난 클라이언트 깔아서 진행함

1. 클라이언트 설치

brew install mysql-client
==> Downloading https://ghcr.io/v2/homebrew/core/mysql-client/manifests/8.2.0
...
==> Caveats
==> mysql-client
mysql-client is keg-only, which means it was not symlinked into /opt/homebrew,
because it conflicts with mysql (which contains client libraries).

If you need to have mysql-client first in your PATH, run:
  echo 'export PATH="/opt/homebrew/opt/mysql-client/bin:$PATH"' >> ~/.zshrc

For compilers to find mysql-client you may need to set:
  export LDFLAGS="-L/opt/homebrew/opt/mysql-client/lib"
  export CPPFLAGS="-I/opt/homebrew/opt/mysql-client/include"

경로를 추가로 설정함

export PKG_CONFIG_PATH="/opt/homebrew/opt/mysql-client/lib/pkgconfig"
export PATH="/opt/homebrew/opt/mysql-client/bin:$PATH"

버전확인

MacBookPro ~ % mysql --version
mysql  Ver 8.2.0 for macos14.0 on arm64 (Homebrew)

2. DBeaver 에서 클라이언트 위치 잡아주기

Local Client ... 버튼 클릭 > 홈 추가 > Command + shift + G

3. mysql 클라이언트 경로 선택 

# 모를경우 설치 위치 찾기
MacBookPro ~ % which mysql
/opt/homebrew/opt/mysql-client/bin/mysql

 

 

 

끗!@#!@#!@#!@#