Homebrew로 macOS에 MariaDB Server 사용하기

brew services stop mariadb

INSTALL

Homebrew 패키지 매니저를 이용해서 MariaDB Server를 macOS (이전 Mac OS X) 설치할 수 있습니다.

•  

  brew install mariadb

• 터미널에서 아래 명령어를 복붙!

EXECUTE

• mariadb server 실행
  

  brew services start mariad

• mariadb server 재실행
  

  brew services restart mariadb​

• mariadb server 중지
  

  brew service stop mariadb

STATUS

• mariadb server 상태 확인
  

  my@MacBook ~ % brew services list          
  # 중지중
  Name    Status User File
  mariadb none     
  # 실행중
  Name    Status  User     File
  mariadb started my ~/Library/LaunchAgents/homebrew.mxcl.mariadb.plist​

LOGIN

• mariadb 또는 mysql 입력 시 비밀번호 확인 없이 현재 맥북 계정으로 로그인
   
• my@MacBook ~ % mariadb Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 7 Server version: 10.6.7-MariaDB Homebrew Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> SELECT USER(); +--------------------+ | USER() | +--------------------+ | my@localhost | +--------------------+ 1 row in set (0.000 sec)​
• root 계정으로 로그인
  

  my@MacBook ~ % sudo mysql -u root
  Password:
  
  Welcome to the MariaDB monitor.  Commands end with ; or \g.
  Your MariaDB connection id is 11
  Server version: 10.6.7-MariaDB Homebrew
  
  Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
  
  Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
  
  MariaDB [(none)]> SELECT USER();
  +----------------+
  | USER()         |
  +----------------+
  | root@localhost |
  +----------------+
  1 row in set (0.000 sec)​