1. 목적
맥북이나 아이맥 등 맥 환경에 MariaBD를 설치한다.
2. 커맨드
$ brew install mariadb
Updating Homebrew...
==> Auto-updated Homebrew!
Updated 1 tap (homebrew/core).
==> New Formulae
kubebuilder now-cli octant pdftk-java pokerstove
==> Updated Formulae
ack dovecot httrack md5sha1sum plantuml softhsm
activemq-cpp duo_unix hyperfine memcached platformio sonobuoy
afflib duplicity i2p mfterm poco sourcery
afl-fuzz dylibbundler i2pd minio podofo sphinx
aircrack-ng dynare icecast minio-mc ponyc spiped
aliyun-cli efl ike-scan miniserve poppler sqlcipher
alpine ejabberd imapfilter mit-scheme pre-commit sqlmap
amap ekg2 intercal mktorrent protobuf srt
amqp-cpp emacs iperf3 mmark protobuf@3.6 ssh-audit
angular-cli embree ipython molecule protobuf@3.7 ssldump
ansible encfs ircd-hybrid monetdb pulledpork starship
ansible@1.9 epic5 ircii mongoose pure-ftpd step
ansible@2.0 erlang@20 irssi monit pwntools storm
apache-spark erlang@21 jenkins monitoring-plugins pwsafe stress-ng
apib eslint jenkins-lts mono pyenv strongswan
appscale-tools ethereum jfrog-cli-go mpg123 pygobject3 stunnel
arangodb exim joplin mupdf pyqt stuntman
aravis exploitdb jose mysql pyside subnetcalc
asio fauna-shell juise mysql@5.7 python@2 sylpheed
astrometry-net fdroidserver juju nagios-plugins pyvim sync_gateway
avfs ffsend kafka nano qca syncthing
aws-sdk-cpp fibjs kore nco qmmp sysdig
awscli findutils krb5 ncrack qpdf tarantool
axel firebase-cli kube-aws neofetch qpid-proton taskell
azure-cli flow kubecfg neon qscintilla2 tcl-tk
azure-storage-cpp flowgrind kubectx net-snmp qsoas tcpdump
bacula-fd fluxctl kubeseal netlify-cli rabbitmq-c tcpflow
bareos-client fn lazydocker nginx rclone tdlib
bash folly ldapvi ngircd rdesktop telegraf
bat fossil ldid nmap re2 tinc
bazel fpp ldns nmh rename tiny-fugue
bbftp-client fq lftp node repo tomcat-native
bcftools freeradius-server libbitcoin nomad riff trafficserver
benthos frugal libbitcoin-blockchain nopoll rmlint triton
bibtexconv gambit-scheme libbitcoin-client nordugrid-arc rom-tools ttyd
bigloo gammu libbitcoin-consensus nrpe root tunnel
blueutil gdal libbitcoin-database nsq rtags typescript
botan geoipupdate libbitcoin-explorer nss ruby u-boot-tools
bro gerbil-scheme libbitcoin-network ntp ruby-build unbound
btfs getdns libbitcoin-node nushell ruby@2.4 unrar
btpd getxbook libbitcoin-protocol nzbget ruby@2.5 unshield
burp git-crypt libbitcoin-server ocrmypdf s-nail uptimed
cabal-install gkrellm libdap ooniprobe s2geometry uwsgi
cadaver glances libdvbpsi opa s3-backer varnish
caf glib libexosip opencolorio sagittarius-scheme vault-cli
cfn-lint glib-openssl libfaketime opencv sane-backends verilator
cgrep globus-toolkit libfreefare opencv@3 sblim-sfcc vgmstream
charm-tools glooctl libgcrypt openfortivpn scamper vim
checkstyle gloox libheif openimageio scdoc vips
chronograf gnupg-pkcs11-scd libjwt openrct2 scrypt visp
clamav gnuradio libmowgli opensc sdhash vtk
clingo gocryptfs libphonenumber openssh sdl2 wdc
collectd goreleaser libpulsar openvpn serverless webpack
conan gradle libre operator-sdk shairport wskdeploy
convox grafana librsvg ophcrack shairport-sync wtf
cpprestsdk groonga libsignal-protocol-c osc ship wtfutil
csound gsl libslax oscats siege xcodegen
cubelib gsoap libtins parallel sile xmake
davix gst-plugins-good libtrace passenger sip youtube-dl
dcmtk gtmess libu2f-server pdftoipe sipsak zabbix
dcos-cli gwyddion links pdns siril zbackup
dhall-bash h2o logrotate pdnsrec skaffold zim
dieharder haproxy logtalk pev skopeo znc
diff-pdf hbase lolcat pgroonga slrn zsxd
diffoscope heimdal luvit php smali
django-completion hive lynx php@7.1 sn0int
dnsviz htpdate mackup php@7.2 sngrep
docfx http_load makensis pjproject socat
doctl httping makepkg pkcs11-helper sofia-sip
==> Deleted Formulae
cherokee freetds@0.91 mongodb mongodb@3.6 tlsdate
csup ftimes mongodb@3.0 percona-server-mongodb tn5250
ctunnel liblacewing mongodb@3.2 pincaster xar-mackyle
frag_find libopkele mongodb@3.4 thc-pptp-bruter
==> Installing dependencies for mariadb: openssl
==> Installing mariadb dependency: openssl
==> Downloading https://homebrew.bintray.com/bottles/openssl-1.0.2s.mojave.bottle.tar.gz
==> Downloading from https://akamai.bintray.com/c4/c4a762d719c2be74ac686f1aafabb32f3c5d5ff3a98935c4925a1ddb9c750ee1?__gda__=exp=156752245
######################################################################## 100.0%
==> Pouring openssl-1.0.2s.mojave.bottle.tar.gz
==> Caveats
A CA file has been bootstrapped using certificates from the SystemRoots
keychain. To add additional certificates (e.g. the certificates added in
the System keychain), place .pem files in
/usr/local/etc/openssl/certs
and run
/usr/local/opt/openssl/bin/c_rehash
openssl is keg-only, which means it was not symlinked into /usr/local,
because Apple has deprecated use of OpenSSL in favor of its own TLS and crypto libraries.
If you need to have openssl first in your PATH run:
echo 'export PATH="/usr/local/opt/openssl/bin:$PATH"' >> ~/.zshrc
For compilers to find openssl you may need to set:
export LDFLAGS="-L/usr/local/opt/openssl/lib"
export CPPFLAGS="-I/usr/local/opt/openssl/include"
==> Summary
🍺 /usr/local/Cellar/openssl/1.0.2s: 1,795 files, 12.0MB
==> Installing mariadb
==> Downloading https://homebrew.bintray.com/bottles/mariadb-10.4.6.mojave.bottle.tar.gz
==> Downloading from https://akamai.bintray.com/8f/8feb884d8e39b94822ea9ed6fa19239b1eea53f6a4496f932908562008a01e35?__gda__=exp=156752246
######################################################################## 100.0%
==> Pouring mariadb-10.4.6.mojave.bottle.tar.gz
==> /usr/local/Cellar/mariadb/10.4.6/bin/mysql_install_db --verbose --user=osstech --basedir=/usr/local/Cellar/mariadb/10.4.6 --datadir=/usr
==> Caveats
A "/etc/my.cnf" from another install may interfere with a Homebrew-built
server starting up correctly.
MySQL is configured to only allow connections from localhost by default
To connect:
mysql -uroot
To have launchd start mariadb now and restart at login:
brew services start mariadb
Or, if you don't want/need a background service you can just run:
mysql.server start
==> Summary
🍺 /usr/local/Cellar/mariadb/10.4.6: 745 files, 173.4MB
==> Caveats
==> openssl
A CA file has been bootstrapped using certificates from the SystemRoots
keychain. To add additional certificates (e.g. the certificates added in
the System keychain), place .pem files in
/usr/local/etc/openssl/certs
and run
/usr/local/opt/openssl/bin/c_rehash
openssl is keg-only, which means it was not symlinked into /usr/local,
because Apple has deprecated use of OpenSSL in favor of its own TLS and crypto libraries.
If you need to have openssl first in your PATH run:
echo 'export PATH="/usr/local/opt/openssl/bin:$PATH"' >> ~/.zshrc
For compilers to find openssl you may need to set:
export LDFLAGS="-L/usr/local/opt/openssl/lib"
export CPPFLAGS="-I/usr/local/opt/openssl/include"
==> mariadb
A "/etc/my.cnf" from another install may interfere with a Homebrew-built
server starting up correctly.
MySQL is configured to only allow connections from localhost by default
To connect:
mysql -uroot
To have launchd start mariadb now and restart at login:
brew services start mariadb
Or, if you don't want/need a background service you can just run:
mysql.server start
3. 확인
mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)