macOS brew로 mariaDB 설치하기

설치환경 OS : macOS sonoma 14.6.1

mariadb 설치/접속

1. brew update

   brew update
   > Already up-to-date.  
   

2. brew로 mariadb 정보 확인

   brew info mariadb
   > ==> mariadb: stable 12.0.2 (bottled)
   > 이하 생략
   

3. brew로 mariadb 설치

   brew install mariadb
   

4. brew로 mariadb를 실행

   brew services start mariadb
   

1. mariadb에 접속

   mariadb
   

   

2. 현재 mariadb에 존재하는 데이터베이스를 출력

   MariaDB [(none)]> show databases;
   +--------------------+
   | Database           |
   +--------------------+
   | information_schema |
   | mysql              |
   | performance_schema |
   | sys                |
   | test               |
   +--------------------+
    5 rows in set (0.005 sec)
   

3. mysql 데이터베이스를 선택 ``` MariaDB [(none)]> use mysql Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A

Database changed

MariaDB [(mysql)]>

8. mariadb 계정 정보 불러오기

MariaDB [mysql]> select host, user, password from user; +————————+————-+———-+ | Host | User | Password | +————————+————-+———-+ | localhost | mariadb.sys | | | localhost | root | invalid | | localhost | juyoung | invalid | | localhost | | | | juyoungui-macbookpro.local| | | +————————+————-+———-+ 5 rows in set (0.003 sec)

9. 루트계정 비밀번호 변경/저장
   - ’test’에 원하는 비밀번호 입력하기

MariaDB [mysql]> set password for ‘root’@’localhost’=password(‘test’); Query OK, 0 rows affected (0.009 sec)

MariaDB [mysql]> select host, user, password from user; +————————+————-+———-+ | Host | User | Password | +————————+————-+———-+ | localhost | mariadb.sys | | | localhost | root | *A4B6157319038724E3560894F7F932C8886EBFCF | | localhost | juyoung | invalid | | localhost | | | | juyoungui-macbookpro.local| | | +————————+————-+———-+ 5 rows in set (0.003 sec)

10. mariadb 종료

MariaDB [mysql]> \q Bye

brew services stop mariadb Stopping mariadb… (might take a while) ==> Successfully stopped mariadb (label: homebrew.mxcl.mariadb) ```

참고자료

• [mac] 맥에서 MariaDB 설치하기 (arm64)