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)