Mac MariaDB 서버 시작 시 뜨는 에러

우선
Mac 에 brew와 mariaDB가 설치 되어 있다는 전제가 깔려있다.

$ brew list
하면 내가 설치한 목록이 나온다.

mysql.server status - DB 서버가 돌고 있는지 확인하기
mysql.server start - DB 서버 시작시키기
mysql.server stop - DB 서버 중지시키기

이다.

시작 시키려고 하는데 아래와 같이 에러 메시지가 나온다.

namdong-gil-ui-MacBookPro:~ namdong-gil$ mysql.server start
/usr/local/Cellar/mariadb/10.3.13/bin/my_print_defaults: Can't read dir of '/usr/local/etc/my.cnf.d' (Errcode: 2 "No such file or directory")
Fatal error in defaults handling. Program aborted
Starting MariaDB
/usr/local/Cellar/mariadb/10.3.13/bin/my_print_defaults: Can't read dir of '/usr/local/etc/my.cnf.d' (Errcode: 2 "No such file or directory")
Fatal error in defaults handling. Program aborted
./usr/local/Cellar/mariadb/10.3.13/bin/my_print_defaults: Can't read dir of '/usr/local/etc/my.cnf.d' (Errcode: 2 "No such file or directory")
Fatal error in defaults handling. Program aborted
190914 15:07:41 mysqld_safe Logging to '/usr/local/var/mysql/namdong-gil-ui-MacBookPro.local.err'.
190914 15:07:41 mysqld_safe Starting mysqld daemon with databases from /usr/local/var/mysql
/usr/local/bin/mysql.server: line 264: kill: (32982) - No such process
 ERROR! 






/usr/local/etc/my.cnf.d 에 파일이나 디렉토리가 없다고 한다.
맥북 업데이트하면 파일을 날리나 보다.

그래서 아래와 같이 파일을 만들어 주면 된다.

namdong-gil-ui-MacBookPro:my.cnf.d namdong-gil$ pwd
/usr/local/etc/my.cnf.d
namdong-gil-ui-MacBookPro:my.cnf.d namdong-gil$ ls
mariadb.cnf mysqld_safe_syslog.cnf tokudb.cnf

namdong-gil-ui-MacBookPro:my.cnf.d namdong-gil$ 

namdong-gil-ui-MacBookPro:my.cnf.d namdong-gil$ cat mariadb.cnf 

# MariaDB-specific config file. # Read by /etc/mysql/my.cnf [client] # Default is Latin1, if you need UTF-8 set this (also in server section) #default-character-set = utf8 [mysqld] # # * Character sets # # Default is Latin1, if you need UTF-8 set all this (also in client section) # #character-set-server = utf8 #collation-server = utf8_general_ci #character_set_server = utf8 #collation_server = utf8_general_ci

namdong-gil-ui-MacBookPro:my.cnf.d namdong-gil$ cat mysqld_safe_syslog.cnf 
[mysqld_safe]

syslog

namdong-gil-ui-MacBookPro:my.cnf.d namdong-gil$ cat tokudb.cnf 
[mariadb] # See https://mariadb.com/kb/en/how-to-enable-tokudb-in-mariadb/
# for instructions how to enable TokuDB
#
# See https://mariadb.com/kb/en/tokudb-differences/ for differences
# between TokuDB in MariaDB and TokuDB from http://www.tokutek.com/




참고 블로그
https://ggogun.tistory.com/entry/mac-mariadb-conf-file-not-exist

댓글

이 블로그의 인기 게시물

About Kafka Basic

About JVM Warm up

About ZGC

Spring Boot Actuator readiness, liveness probes on k8s

About G1 GC

sneak peek jitpack

About idempotent

C 언어 구조체의 포인터 멤버 변수

Synology NAS에 MariaDB 10에 Mysql workbench로 원격접속하기

About Websocket minimize data size and data transfer cost on cloud