Print
카테고리: [ MariaDB ]
조회수: 37409

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)