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 JVM Warm up

About idempotent

About Kafka Basic

About ZGC

sneak peek jitpack

Spring Boot Actuator readiness, liveness probes on k8s

About Websocket minimize data size and data transfer cost on cloud

About G1 GC

대학생 코딩 과제 대행 java, python, oracle 네 번째