1 건의
homebrew 검색결과

마리아DB(mariadb)를 homebrew를 이용해서 설치 시 MariaDB가 꺼져있으면 콘솔을 이용해서 켜는 것이 제일 편하긴 하다



$ mysql.server start

/usr/local/Cellar/mariadb/10.1.19/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 MySQL
./usr/local/Cellar/mariadb/10.1.19/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.1.19/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
161128 14:58:43 mysqld_safe Logging to '/usr/local/var/mysql/Macbook.local.err'.
ERROR!

그런데!!! 맥의 OS 업데이트를 하고 나니 다음과 같은 에러가 나왔다


왜 Config 파일들이 사라졌다고 하는 것일까


다음과 같은 파일들을 만들어주면 해결이 된다


/usr/local/etc/my.cnf

#
# This group is read both both by the client and the server

# use it for options that affect everything

#

[client-server]

#

# include all files from the config directory

#

!includedir /usr/local/etc/my.cnf.d



/usr/local/etc/my.cnf.d/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 

/usr/local/etc/my.cnf.d/mysqld_safe_syslog.cnf
[mysqld_safe]
syslog

/usr/local/etc/my.cnf.d/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/


TokenMarket ICO calendar