由于MySQL的官网5.6.42版本的没有MacOS系统的安装文件,所以在终端使用命令行操作下载.下面将命令行窗口的操作以及配置过程的代码留个笔记,以供需要的小伙伴查询.

Last login: Wed Jan  2 17:02:31 on ttys000
liangyufengdeMacBook-Pro:~ liangyufeng$ brew
Example usage:brew search [TEXT|/REGEX/]brew info [FORMULA...]brew install FORMULA...brew updatebrew upgrade [FORMULA...]brew uninstall FORMULA...brew list [FORMULA...]Troubleshooting:brew configbrew doctorbrew install --verbose --debug FORMULAContributing:brew create [URL [--no-fetch]]brew edit [FORMULA...]Further help:brew commandsbrew help [COMMAND]man brewhttps://docs.brew.sh
liangyufengdeMacBook-Pro:~ liangyufeng$ 
liangyufengdeMacBook-Pro:~ liangyufeng$ 
liangyufengdeMacBook-Pro:~ liangyufeng$ brew tap homebrew/versions
==> Installing dependencies for git: gettext, pcre2
==> Installing git dependency: gettext
==> Downloading https://homebrew.bintray.com/bottles/gettext-0.19.8.1.mojave.bot
Updating Homebrew...
#######################################################                   76.6%^C
Error: Git must be installed and in your PATH!
Error: homebrew/versions was deprecated. This tap is now empty as all its formulae were migrated.
liangyufengdeMacBook-Pro:~ liangyufeng$ brew info mysql
xcrun: error: invalid active developer path (/Library/Developer/CommandLineTools), missing xcrun at: /Library/Developer/CommandLineTools/usr/bin/xcrun
mysql: stable 8.0.12 (bottled)
Open source relational database management system
https://dev.mysql.com/doc/refman/8.0/en/
Conflicts with:mariadb (because mysql, mariadb, and percona install the same binaries.)mariadb-connector-c (because both install plugins)mysql-cluster (because mysql, mariadb, and percona install the same binaries.)mysql-connector-c (because both install MySQL client libraries)percona-server (because mysql, mariadb, and percona install the same binaries.)
Not installed
From: /usr/local/Homebrew/Library/Taps/homebrew/homebrew-core/Formula/mysql.rb
==> Dependencies
Build: cmake ✘
Required: openssl ✔
==> Requirements
Required: macOS >= 10.10 ✔
==> Options
--with-embeddedBuild the embedded server
--with-local-infileBuild with local infile loading support
--with-memcachedBuild with InnoDB Memcached plugin
==> Caveats
We've installed your MySQL database without a root password. To secure it run:mysql_secure_installationMySQL is configured to only allow connections from localhost by defaultTo connect run:mysql -urootTo have launchd start mysql now and restart at login:brew services start mysql
Or, if you don't want/need a background service you can just run:mysql.server start
liangyufengdeMacBook-Pro:~ liangyufeng$ 
liangyufengdeMacBook-Pro:~ liangyufeng$ 
liangyufengdeMacBook-Pro:~ liangyufeng$ clearliangyufengdeMacBook-Pro:~ liangyufeng$ 
liangyufengdeMacBook-Pro:~ liangyufeng$ 
liangyufengdeMacBook-Pro:~ liangyufeng$ 
liangyufengdeMacBook-Pro:~ liangyufeng$ 
liangyufengdeMacBook-Pro:~ liangyufeng$ 
liangyufengdeMacBook-Pro:~ liangyufeng$ brew info mysql
xcrun: error: invalid active developer path (/Library/Developer/CommandLineTools), missing xcrun at: /Library/Developer/CommandLineTools/usr/bin/xcrun
mysql: stable 8.0.12 (bottled)
Open source relational database management system
https://dev.mysql.com/doc/refman/8.0/en/
Conflicts with:mariadb (because mysql, mariadb, and percona install the same binaries.)mariadb-connector-c (because both install plugins)mysql-cluster (because mysql, mariadb, and percona install the same binaries.)mysql-connector-c (because both install MySQL client libraries)percona-server (because mysql, mariadb, and percona install the same binaries.)
Not installed
From: /usr/local/Homebrew/Library/Taps/homebrew/homebrew-core/Formula/mysql.rb
==> Dependencies
Build: cmake ✘
Required: openssl ✔
==> Requirements
Required: macOS >= 10.10 ✔
==> Options
--with-embeddedBuild the embedded server
--with-local-infileBuild with local infile loading support
--with-memcachedBuild with InnoDB Memcached plugin
==> Caveats
We've installed your MySQL database without a root password. To secure it run:mysql_secure_installationMySQL is configured to only allow connections from localhost by defaultTo connect run:mysql -urootTo have launchd start mysql now and restart at login:brew services start mysql
Or, if you don't want/need a background service you can just run:mysql.server start
==> Analytics
install: 63,161 (30d), 183,957 (90d), 888,341 (365d)
install_on_request: 57,982 (30d), 172,668 (90d), 790,136 (365d)
build_error: 0 (30d)
liangyufengdeMacBook-Pro:~ liangyufeng$ mysql
-bash: mysql: command not found
liangyufengdeMacBook-Pro:~ liangyufeng$ brew install mysql
==> Installing dependencies for git: gettext, pcre2
==> Installing git dependency: gettext
==> Downloading https://homebrew.bintray.com/bottles/gettext-0.19.8.1.mojave.bottle.tar.gz
Updating Homebrew...
############                                                              17.8%^C
Error: Git must be installed and in your PATH!
xcrun: error: invalid active developer path (/Library/Developer/CommandLineTools), missing xcrun at: /Library/Developer/CommandLineTools/usr/bin/xcrun
==> Downloading https://homebrew.bintray.com/bottles/mysql-8.0.12.mojave.bottle.tar.gz
^C
liangyufengdeMacBook-Pro:~ liangyufeng$ brew install mysql5.6
==> Installing dependencies for git: gettext, pcre2
==> Installing git dependency: gettext
==> Downloading https://homebrew.bintray.com/bottles/gettext-0.19.8.1.mojave.bottle.tar.gz
Updating Homebrew...
######################################################################## 100.0%
==> Pouring gettext-0.19.8.1.mojave.bottle.tar.gz
==> Caveats
gettext is keg-only, which means it was not symlinked into /usr/local,
because macOS provides the BSD gettext library & some software gets confused if both are in the library path.If you need to have gettext first in your PATH run:echo 'export PATH="/usr/local/opt/gettext/bin:$PATH"' >> ~/.bash_profileFor compilers to find gettext you may need to set:export LDFLAGS="-L/usr/local/opt/gettext/lib"export CPPFLAGS="-I/usr/local/opt/gettext/include"==> Summary
?  /usr/local/Cellar/gettext/0.19.8.1: 1,935 files, 16.9MB
==> Installing git dependency: pcre2
==> Downloading https://homebrew.bintray.com/bottles/pcre2-10.32.mojave.bottle.tar.gz
######################################################################## 100.0%
==> Pouring pcre2-10.32.mojave.bottle.tar.gz
?  /usr/local/Cellar/pcre2/10.32: 224 files, 5.5MB
==> Installing git
==> Downloading https://homebrew.bintray.com/bottles/git-2.19.1.mojave.bottle.tar.gz
######################################################################## 100.0%
==> Pouring git-2.19.1.mojave.bottle.tar.gz
==> Caveats
Bash completion has been installed to:/usr/local/etc/bash_completion.dzsh completions and functions have been installed to:/usr/local/share/zsh/site-functionsEmacs Lisp files have been installed to:/usr/local/share/emacs/site-lisp/git
==> Summary
?  /usr/local/Cellar/git/2.19.1: 1,518 files, 40.1MB
==> Caveats
==> gettext
gettext is keg-only, which means it was not symlinked into /usr/local,
because macOS provides the BSD gettext library & some software gets confused if both are in the library path.If you need to have gettext first in your PATH run:echo 'export PATH="/usr/local/opt/gettext/bin:$PATH"' >> ~/.bash_profileFor compilers to find gettext you may need to set:export LDFLAGS="-L/usr/local/opt/gettext/lib"export CPPFLAGS="-I/usr/local/opt/gettext/include"==> git
Bash completion has been installed to:/usr/local/etc/bash_completion.dzsh completions and functions have been installed to:/usr/local/share/zsh/site-functionsEmacs Lisp files have been installed to:/usr/local/share/emacs/site-lisp/git
xcrun: error: invalid active developer path (/Library/Developer/CommandLineTools), missing xcrun at: /Library/Developer/CommandLineTools/usr/bin/xcrun
==> Auto-updated Homebrew!
Updated 1 tap (homebrew/core).
==> New Formulae
anycable-go              dav1d                    gitmoji                  jmxterm                  maven@3.5                oxipng                   rke                      sourcedocs
aom                      dhall                    goreman                  kubeseal                 mesa                     pass-otp                 ruby@2.4                 spice-protocol
astrometry-net           dnscontrol               healpix                  kubespy                  minica                   pict                     ruby@2.5                 swagger-codegen@2
atomist-cli              easyengine               hexyl                    libcerf                  moarvm                   postgresql@10            shellz                   switch-lan-play
azure-storage-cpp        eg-examples              i386-elf-binutils        libgusb                  needle                   qalculate-gtk            ship                     tass64
c-blosc                  esptool                  i386-elf-gcc             libnova                  node@10                  rakudo                   simple-scan              tealdeer
cgit                     fluxctl                  i386-elf-gdb             libpulsar                nqp                      rargs                    sloc                     termtosvg
create-dmg               fx                       inadyn                   libvirt-glib             nu-smv                   react-native-cli         sng                      um
cryptominisat            gambit-scheme            interactive-rebase-tool  libvmaf                  objfw                    redis@4.0                solr@6.6                 up
curl-openssl             ghr                      istioctl                 lsd                      opa                      resin-cli                sonobuoy                 websocat
==> Updated Formulae
gdbm ✔                                  docker-machine-parallels                ibex                                    mongo-c-driver                          scipy
git ✔                                   docker-squash                           icdiff                                  mongo-cxx-driver                        scour
libpng ✔                                doctl                                   icecream                                mongo-orchestration                     scrcpy
libtiff ✔                               docutils                                icemon                                  mongodb                                 sdb
mercurial ✔                             doitlive                                icu4c                                   mongodb@3.4                             sdcc
openssl ✔                               dosbox-x                                idris                                   mongodb@3.6                             sdl2
portmidi ✔                              dovecot                                 ike-scan                                mongoose                                sdl2_image
sphinx-doc ✔                            doxygen                                 imagemagick                             mono                                    sdl2_mixer
sqlite ✔                                dpkg                                    imagemagick@6                           mosquitto                               sec
webp ✔                                  druid                                   imageoptim-cli                          mozjpeg                                 selenium-server-standalone
abcm2ps                                 dscanner                                imageworsener                           mpc                                     serverless
abyss                                   dub                                     imapfilter                              mpd                                     sfcgal
ace                                     duc                                     immortal                                mpich                                   shadowsocks-libev
activemq                                duo_unix                                influxdb                                mplayer                                 shairport-sync
advancecomp                             duplicity                               innotop                                 mps-youtube                             shc
advancemame                             dvm                                     inspircd                                mpv                                     shellcheck
adwaita-icon-theme                      dwdiff                                  instead                                 mruby                                   shellshare
agda                                    dwm                                     internetarchive                         mu                                      shfmt
aha                                     dynare                                  ioping                                  muparser                                shibboleth-sp
aircrack-ng                             e2fsprogs                               ios-deploy                              mupdf                                   shocco
akamai                                  eccodes                                 ios-webkit-debug-proxy                  mupdf-tools                             shogun
alexjs                                  ed                                      ipfs                                    mutt                                    signify-osx
algernon                                editorconfig                            iproute2mac                             mycli                                   sile
allure                                  efl                                     ipython                                 mysql                                   simple-amqp-client
alluxio                                 eigen                                   isync                                   mysql@5.5                               sip
amazon-ecs-cli                          ejabberd                                itstool                                 mysql@5.6                               siril
ammonite-repl                           elasticsearch                           jabba                                   mysql@5.7                               skaffold
amqp-cpp                                elasticsearch@5.6                       jansson                                 mysqltuner                              skafos
angle-grinder                           elektra                                 jbake                                   n                                       skinny
angular-cli                             elixir                                  jbig2dec                                nailgun                                 skopeo
anjuta                                  emacs-clang-complete-async              jboss-forge                             nano                                    sleuthkit
annie                                   embulk                                  jdnssec-tools                           nanomsg                                 smartmontools
ansible                                 emscripten                              jdupes                                  nasm                                    smimesign
ansible-cmdb                            envconsul                               jena                                    nativefier                              snapcraft
ansifilter                              eprover                                 jenkins                                 nats-streaming-server                   snappystream
antlr                                   epubcheck                               jenkins-job-builder                     ncmpcpp                                 snapraid
antlr4-cpp-runtime                      eralchemy                               jenkins-lts                             nco                                     sngrep
antlr@2                                 erlang                                  jetty                                   ncview                                  softhsm
apache-arrow                            erlang@17                               jflex                                   ne                                      solr
apache-arrow-glib                       erlang@18                               jfrog-cli-go                            neo4j                                   sonar-scanner
apache-drill                            erlang@19                               jhipster                                neofetch                                sonarqube
apache-flink                            erlang@20                               jid                                     neovim                                  sops
apache-geode                            eslint                                  joplin                                  netcdf                                  source-highlight
apache-spark                            etcd                                    jq                                      netdata                                 source-to-image
app-engine-java                         ethereum                                jrnl                                    netpbm                                  sourcekitten
aptly                                   euler-py                                json-fortran                            nettle                                  sox
arangodb                                evince                                  jsonnet                                 newsboat                                spades
arcade-learning-environment             exercism                                jsonrpc-glib                            nexus                                   spdlog
ark                                     exiv2                                   juju                                    nghttp2                                 spotbugs
armadillo                               exploitdb                               jump                                    nginx                                   sqlcipher
armor                                   eye-d3                                  just                                    ngspice                                 sqldiff
arx                                     faas-cli                                kafka                                   nifi                                    sqlite-analyzer
asciidoc                                fabio                                   kakoune                                 nmh                                     sqlmap
asciidoctor                             fabric                                  kallisto                                nng                                     sqlparse
asdf                                    fatsort                                 kapacitor                               nnn                                     sratoolkit
aspectj                                 fauna-shell                             khal                                    node                                    ssh-copy-id
atdtool                                 fb-client                               kibana                                  node-build                              sshconfigfs
aubio                                   fbi-servefiles                          kibana@5.6                              node@6                                  sshuttle
augustus                                fd                                      kitchen-sync                            node@8                                  sslmate
autopep8                                fdk-aac                                 knot                                    nodeenv                                 sslscan
autorest                                fdk-aac-encoder                         knot-resolver                           nodenv                                  statik
aws-es-proxy                            feedgnuplot                             kobalt                                  nsd                                     stellar-core
aws-sdk-cpp                             feh                                     kompose                                 nss                                     stern
awscli                                  ffmpeg                                  konoha                                  numpy                                   stgit
awslogs                                 ffmpeg2theora                           kontena                                 nuxeo                                   stockfish
azure-cli                               ffmpeg@2.8                              kops                                    nvm                                     stone-soup
b2-tools                                ffmpegthumbnailer                       kotlin                                  nwchem                                  stormpath-cli
babel                                   ffms2                                   krakend                                 nyx                                     stormssh
babl                                    field3d                                 krb5                                    ocaml                                   streamlink
ballerina                               file-formula                            kube-aws                                ocaml-num                               stubby
basex                                   fio                                     kubectx                                 ocamlbuild                              stunnel
bash                                    firebase-cli                            kubeless                                ocamlsdl                                subversion
bash-snippets                           fish                                    kubernetes-cli                          ocrmypdf                                sundials
bat                                     flake8                                  kubernetes-helm                         octave                                  supervisor
bazel                                   flann                                   kubernetes-service-catalog-client       odpi                                    suricata
bcal                                    fltk                                    kustomize                               ompl                                    svtplay-dl
bde                                     fluent-bit                              lablgtk                                 oniguruma                               swagger-codegen
bdw-gc                                  fluid-synth                             landscaper                              opam                                    swi-prolog
beagle                                  flume                                   languagetool                            open-mpi                                swift
beast                                   flyway                                  lasso                                   open-scene-graph                        swift-protobuf
bento4                                  fmpp                                    lastpass-cli                            openapi-generator                       swiftformat
bettercap                               fmt                                     laszip                                  openblas                                swiftlint
bgpdump                                 fn                                      latex2html                              opencascade                             swimat
bgpq3                                   fobis                                   latexdiff                               opencoarrays                            sync_gateway
bigloo                                  folly                                   lcm                                     openconnect                             syncthing
binaryen                                fonttools                               ldc                                     opencv                                  sysbench
bind                                    ford                                    lean-cli                                opencv@2                                sysdig
binutils                                fork-cleaner                            ledger                                  openfortivpn                            tarantool
binwalk                                 fping                                   legit                                   openimageio                             tarsnapper
bison                                   fq                                      lego                                    openldap                                taskell
bitcoin                                 freeciv                                 leiningen                               openmsx                                 tbb
bitrise                                 freeling                                leptonica                               openrct2                                tcc
bitwarden-cli                           freetds                                 less                                    openrtsp                                tcpdump
blackbox                                freetds@0.91                            lgogdownloader                          openshift-cli                           tcpreplay
blast                                   frugal                                  libassuan                               openssh                                 tectonic
blink1                                  fruit                                   libatomic_ops                           openssl@1.1                             telegraf
bluepill                                fselect                                 libav                                   opentsdb                                teleport
blueutil                                fswatch                                 libbi                                   openvdb                                 temporal_tables
bmake                                   fuseki                                  libbitcoin                              opus                                    tepl
bnd                                     futhark                                 libbitcoin-blockchain                   opus-tools                              termius
boost                                   fwup                                    libbitcoin-client                       opusfile                                termrec
boost-bcp                               gammaray                                libbitcoin-database                     orc-tools                               terraform
boost-build                             gandi.cli                               libbitcoin-explorer                     osm2pgrouting                           terraform-docs
boost-mpi                               gauche                                  libbitcoin-network                      osmium-tool                             terraform_landscape
boost-python                            gauge                                   libbitcoin-node                         osquery                                 terragrunt
boost-python3                           gcab                                    libbitcoin-protocol                     osrm-backend                            tesseract
botan                                   gcc@6                                   libbitcoin-server                       oysttyer                                testssl
bowtie2                                 gcc@7                                   libbladerf                              pacapt                                  tgui
braid                                   gdal                                    libbtbb                                 packer                                  thefuck
brew-php-switcher                       gdb                                     libccd                                  pagmo                                   theharvester
brogue                                  gdcm                                    libcdr                                  paket                                   thors-serializer
brotli                                  gecode                                  libcds                                  pandoc                                  tika
btfs                                    gedit                                   libcec                                  pandoc-citeproc                         tile38
buildifier                              geeqie                                  libcouchbase                            pandoc-crossref                         tinc
buku                                    gegl                                    libdazzle                               pangomm                                 tinyproxy
bullet                                  genometools                             libdill                                 parallel                                tinyxml2
bundletool                              geos                                    libedit                                 parallelstl                             tippecanoe
bup                                     get_iplayer                             liberasurecode                          passenger                               tmux
byteman                                 getdns                                  libetpan                                passpie                                 tmuxinator-completion
bzt                                     gexiv2                                  libextractor                            payara                                  tomcat
c-ares                                  gflags                                  libfabric                               pazpar2                                 tomcat-native
c10t                                    ghc                                     libfreehand                             pcl                                     tomcat@7
cabal-install                           ghostscript                             libgcrypt                               pdal                                    tomcat@8
cabextract                              gimme                                   libgda                                  pdfpc                                   tomee-webprofile
caddy                                   git-annex                               libgit2                                 pdftoedn                                topgrade
caf                                     git-archive-all                         libgit2-glib                            pdftoipe                                tor
caffe                                   git-cinnabar                            libgosu                                 percol                                  tox
cairo                                   git-lfs                                 libgpg-error                            percona-server                          traefik
cake                                    git-open                                libgphoto2                              percona-server@5.6                      translate-shell
calc                                    git-quick-stats                         libgsf                                  percona-toolkit                         translate-toolkit
camlp5                                  git-recent                              libgxps                                 perl                                    trash-cli
capstone                                git-review                              libhttpserver                           petsc                                   travis
cargo-completion                        git-standup                             libical                                 petsc-complex                           tree
carla                                   git-subrepo                             libidn2                                 pgbadger                                treefrog
carthage                                gitbucket                               libimagequant                           pgcli                                   tty-solitaire
cassandra                               gitfs                                   libjson-rpc-cpp                         pgformatter                             ttyd
catimg                                  gitg                                    libjwt                                  pgroonga                                tundra
cayley                                  github-markdown-toc                     liblcf                                  pgrouting                               tunnel
ccache                                  gitlab-gem                              liblo                                   pgweb                                   tup
ccextractor                             gitlab-runner                           libmagic                                phoronix-test-suite                     tvnamer
cclive                                  gitless                                 libmatio                                php                                     twarc
ccm                                     gitversion                              libmicrohttpd                           php-code-sniffer                        twine-pypi
ceres-solver                            gjs                                     libmspub                                php-cs-fixer                            twoping
cern-ndiff                              glances                                 libmxml                                 php@7.1                                 typescript
certbot                                 glib                                    libnice                                 phpmyadmin                              ubertooth
certigo                                 glibmm                                  libomp                                  phpunit                                 ucloud
cfitsio                                 glm                                     libopendkim                             picard-tools                            uhd
cglm                                    global                                  libopusenc                              picat                                   unbound
chakra                                  globjects                               libosmium                               pig                                     uncrustify
chamber                                 glslang                                 libphonenumber                          pijul                                   unnethack
cheat                                   gmic                                    libplctag                               pike                                    unoconv
checkbashisms                           gmime                                   libplist                                pilosa                                  unshield
checkstyle                              gmsh                                    libpq                                   pip-completion                          upscaledb
chicken                                 gmt                                     libpqxx                                 pipenv                                  urdfdom_headers
chisel                                  gmt@4                                   libproxy                                pius                                    urh
choose                                  gnome-latex                             libpsl                                  pixman                                  uriparser
chrome-export                           gnu-sed                                 libpst                                  pktanon                                 uru
chronograf                              gnu-tar                                 libqalculate                            planck                                  urweb
chruby-fish                             gnu-units                               librdkafka                              plantuml                                v8
circleci                                gnupg                                   librealsense                            platformio                              vagrant-completion
citus                                   gnuplot                                 libressl                                plplot                                  vala
ckan                                    gnuradio                                librsvg                                 pmd                                     valgrind
clamav                                  gnutls                                  libsamplerate                           pngquant                                vapoursynth
clang-format                            go                                      libsass                                 podofo                                  varnish
clblast                                 go-bindata                              libsecret                               ponyc                                   vault
cli53                                   go-statik                               libsigc++                               poppler                                 vaulted
cling                                   go@1.10                                 libsodium                               posh                                    vegeta
clojure                                 goaccess                                libsoup                                 postgis                                 verilator
clojurescript                           gobject-introspection                   libspectre                              postgresql                              vert.x
closure-compiler                        gocryptfs                               libssh                                  ppsspp                                  vfuse
cmake                                   godep                                   libstfl                                 pqiv                                    vice
cmark-gfm                               goenv                                   libswiften                              pre-commit                              vim
cmdshelf                                goffice                                 libtcod                                 presto                                  vim@7.4
cnats                                   golang-migrate                          libtensorflow                           prettier                                vips
cockroach                               googler                                 libtins                                 primesieve                              visp
cocoapods                               goolabs                                 libtorrent-rasterbar                    prips                                   vnu
codemod                                 gopass                                  libuv                                   prometheus                              voldemort
cointop                                 goreleaser                              libvirt                                 proselint                               vsts-cli
collectd                                gosu                                    libvisio                                protobuf                                vte3
collector-sidecar                       gowsdl                                  libvoikko                               ps2eps                                  vtk
commandbox                              gpa                                     libwebsockets                           pspg                                    wabt
composer                                gpgme                                   libxlsxwriter                           pulumi                                  wakatime-cli
conan                                   gphoto2                                 libxml2                                 pumba                                   wallpaper
configen                                gprof2dot                               libxmlsec1                              purescript                              wartremover
confluent-oss                           gpsbabel                                libxslt                                 pushpin                                 watchman
console_bridge                          gr-osmosdr                              lighttpd                                pwntools                                watson
consul                                  gradio                                  linkerd                                 py2cairo                                wcslib
container-diff                          gradle                                  livestreamer                            py3cairo                                weaver
convox                                  grafana                                 llvm                                    pyenv                                   weboob
cookiecutter                            grails                                  llvm@3.9                                pygitup                                 webpack
coq                                     grakn                                   llvm@4                                  pygobject3                              weechat
couchdb                                 graph-tool                              llvm@5                                  pyinvoke                                wesnoth
cp2k                                    graphicsmagick                          llvm@6                                  python                                  wget
cpanminus                               graphite2                               lmdb                                    python-markdown                         when
cppcheck                                grep                                    lmod                                    q                                       whois
cpprestsdk                              grib-api                                logstash                                qbs                                     widelands
crc32c                                  grip                                    logtalk                                 qcli                                    wine
credstash                               groff                                   lolcat                                  qemu                                    winetricks
cromwell                                groovy                                  lsdvd                                   qmmp                                    wireguard-go
crosstool-ng                            groovysdk                               lumo                                    qpdf                                    wireguard-tools
crowdin                                 grpc                                    luvit                                   qpid-proton                             wireshark
cryptopp                                grunt-cli                               lxc                                     qt                                      woboq_codebrowser
crystal                                 grunt-completion                        lynis                                   quicktype                               wolfssl
crystal-icr                             grv                                     mackup                                  r                                       wp-cli
cucumber-cpp                            gst-plugins-good                        macvim                                  rabbitmq                                wp-cli-completion
curaengine                              gst-plugins-ugly                        magic-wormhole                          radare2                                 wpscan
curl                                    gst-python                              makensis                                rakudo-star                             wskdeploy
cvs2svn                                 gstreamermm                             mame                                    rancher-cli                             wtf
cython                                  gtk+3                                   mandoc                                  range-v3                                wxmaxima
dartsim                                 gtk-doc                                 mapnik                                  rbspy                                   x264
dash                                    gtkmm3                                  mapserver                               rclone                                  xcodegen
dasht                                   gtkspell3                               mariadb                                 rdesktop                                xctool
dateutils                               gucharmap                               mariadb-connector-c                     re2                                     xmake
davix                                   gupnp-av                                mariadb@10.0                            rebar3                                  xml-security-c
dbhash                                  gupnp-tools                             mariadb@10.1                            recon-ng                                xml-tooling-c
dbus                                    gwyddion                                mariadb@10.2                            recutils                                xmrig
dcd                                     gzip                                    mas                                     redis                                   xonsh
dcm2niix                                hadolint                                math-comp                               redo                                    xsimd
ddgr                                    handbrake                               maven                                   remarshal                               xtensor
dependency-check                        hapi-fhir-cli                           maxwell                                 repo                                    yaml-cpp
dfmt                                    haproxy                                 mdcat                                   restic                                  yamllint
dhall-json                              harfbuzz                                mdp                                     restview                                yank
dialog                                  hashpump                                mdv                                     riemann-client                          yara
diamond                                 haskell-stack                           media-info                              rmlint                                  yarn
diceware                                haste-client                            megacmd                                 robot-framework                         yasm
diff-pdf                                hbase                                   memcached                               rom-tools                               yaz
diffoscope                              hcloud                                  meson                                   root                                    ydcv
diffutils                               hdf5                                    metaproxy                               roswell                                 ykman
digdag                                  hdf5@1.8                                micronaut                               rpm                                     yle-dl
digitemp                                hebcal                                  midnight-commander                      rst-lint                                yosys
direnv                                  helmfile                                mikutter                                rswift                                  you-get
dita-ot                                 help2man                                mill                                    rtags                                   youtube-dl
django-completion                       hfstospell                              miller                                  ruby                                    yq
dlib                                    highlight                               mimic                                   ruby-build                              z3
dmd                                     hiredis                                 minio                                   ruby@2.3                                zanata-client
dnscrypt-proxy                          hive                                    minio-mc                                rust                                    zebra
dnscrypt-wrapper                        hmmer                                   miniserve                               rustup-init                             zeromq
dnsmasq                                 homebank                                minizinc                                s-search                                zile
dnstwist                                honcho                                  mint                                    s3cmd                                   zim
docfx                                   howdoi                                  mitie                                   safe                                    zimg
docker                                  http-parser                             mkcert                                  sagittarius-scheme                      znc
docker-completion                       httpd                                   mkclean                                 salt                                    zookeeper
docker-compose                          httpie                                  mkdocs                                  sbcl                                    zorba
docker-compose-completion               hub                                     mkl-dnn                                 sbt                                     zsh
docker-credential-helper-ecr            hugo                                    mkvtoolnix                              sbt@0.13                                zsh-autosuggestions
docker-ls                               hunspell                                mlt                                     scala                                   zsh-completions
docker-machine                          hwloc                                   mmseqs2                                 scalaenv                                zstd
docker-machine-completion               hydra                                   mockserver                              scalapack                               zurl
docker-machine-driver-xhyve             hyperfine                               monero                                  sceptre
docker-machine-nfs                      i2pd                                    monetdb                                 schismtracker
==> Renamed Formulae
gtksourceview@4 -> gtksourceview4       gutenberg -> zola                       hh -> hstr                              mat -> mat2                             php72 -> php@7.2
==> Deleted Formulae
apple-gcc42         corebird            gnome-doc-utils     heroku              ld64                mimms               open-vcdiff         pldebugger          reclass             sickbeard
aptly-completion    datomic             gradle@2.14         ib                  lsh                 nesemu2             opensyobon          pxz                 rock                taylor
cctools             ffmbc               gv                  juju-quickstart     maven@3.0           nethack4            php@5.6             pyexiv2             ruby@2.2            tcptrack
cctools-headers     gjstest             hachoir-metadata    kibana@4.4          maven@3.1           onepass             php@7.0             queequeg            saryError: HOMEBREW_LOGS was not exported!
Please don't worry, you likely hit a bug auto-updating from an old version.
Rerun your command, everything is up-to-date and fine now.
liangyufengdeMacBook-Pro:~ liangyufeng$ which mysql
liangyufengdeMacBook-Pro:~ liangyufeng$ mysql
-bash: mysql: command not found
liangyufengdeMacBook-Pro:~ liangyufeng$ 
liangyufengdeMacBook-Pro:~ liangyufeng$ 
liangyufengdeMacBook-Pro:~ liangyufeng$ cd /usr/local/Cellar/
freetype/   gettext/    jpeg/       libogg/     libtiff/    mercurial/  pcre2/      portmidi/   readline/   sdl_image/  sdl_ttf/    sqlite/     
gdbm/       git/        libmikmod/  libpng/     libvorbis/  openssl/    pkg-config/ python@2/   sdl/        sdl_mixer/  sphinx-doc/ webp/       
liangyufengdeMacBook-Pro:~ liangyufeng$ cd /usr/local/Cellar/
liangyufengdeMacBook-Pro:Cellar liangyufeng$ ll
-bash: ll: command not found
liangyufengdeMacBook-Pro:Cellar liangyufeng$ ls
freetype	gettext		jpeg		libogg		libtiff		mercurial	pcre2		portmidi	readline	sdl_image	sdl_ttf		sqlite
gdbm		git		libmikmod	libpng		libvorbis	openssl		pkg-config	python@2	sdl		sdl_mixer	sphinx-doc	webp
liangyufengdeMacBook-Pro:Cellar liangyufeng$ ls -lrt
total 0
drwxr-xr-x  3 liangyufeng  staff  96 10  9 00:13 gdbm
drwxr-xr-x  3 liangyufeng  staff  96 10  9 00:13 openssl
drwxr-xr-x  3 liangyufeng  staff  96 10  9 00:14 readline
drwxr-xr-x  3 liangyufeng  staff  96 10  9 00:14 sqlite
drwxr-xr-x  3 liangyufeng  staff  96 10  9 00:21 pkg-config
drwxr-xr-x  3 liangyufeng  staff  96 10  9 00:21 sphinx-doc
drwxr-xr-x  3 liangyufeng  admin  96 10  9 00:22 python@2
drwxr-xr-x  3 liangyufeng  staff  96 10  9 00:28 mercurial
drwxr-xr-x  3 liangyufeng  staff  96 10  9 00:28 sdl
drwxr-xr-x  3 liangyufeng  staff  96 10  9 00:28 jpeg
drwxr-xr-x  3 liangyufeng  staff  96 10  9 00:28 libpng
drwxr-xr-x  3 liangyufeng  staff  96 10  9 00:28 libtiff
drwxr-xr-x  3 liangyufeng  staff  96 10  9 00:28 webp
drwxr-xr-x  3 liangyufeng  staff  96 10  9 00:28 sdl_image
drwxr-xr-x  3 liangyufeng  staff  96 10  9 00:29 freetype
drwxr-xr-x  3 liangyufeng  staff  96 10  9 00:29 sdl_ttf
drwxr-xr-x  3 liangyufeng  staff  96 10  9 00:32 libmikmod
drwxr-xr-x  3 liangyufeng  staff  96 10  9 00:32 libogg
drwxr-xr-x  3 liangyufeng  staff  96 10  9 00:32 libvorbis
drwxr-xr-x  3 liangyufeng  staff  96 10  9 00:32 sdl_mixer
drwxr-xr-x  3 liangyufeng  staff  96 10  9 00:32 portmidi
drwxr-xr-x  3 liangyufeng  staff  96  1 11 20:06 gettext
drwxr-xr-x  3 liangyufeng  staff  96  1 11 20:06 pcre2
drwxr-xr-x  3 liangyufeng  staff  96  1 11 20:08 git
liangyufengdeMacBook-Pro:Cellar liangyufeng$ brew install mysql@5.6.42
Error: No available formula with the name "mysql@5.6.42" 
==> Searching for a previously deleted formula (in the last month)...
Warning: homebrew/core is shallow clone. To get complete history run:git -C "$(brew --repo homebrew/core)" fetch --unshallowError: No previously deleted formula found.
==> Searching for similarly named formulae...
Error: No similarly named formulae found.
==> Searching taps...
==> Searching taps on GitHub...
Error: No formulae found in taps.
liangyufengdeMacBook-Pro:Cellar liangyufeng$ brew install mysql@5.6
==> Installing dependencies for mysql@5.6: openssl
==> Installing mysql@5.6 dependency: openssl
==> Downloading https://homebrew.bintray.com/bottles/openssl-1.0.2q.mojave.bottle.tar.gz
######################################################################## 100.0%
==> Pouring openssl-1.0.2q.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/certsand run/usr/local/opt/openssl/bin/c_rehashopenssl 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"' >> ~/.bash_profileFor 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"For pkg-config to find openssl you may need to set:export PKG_CONFIG_PATH="/usr/local/opt/openssl/lib/pkgconfig"==> Summary
?  /usr/local/Cellar/openssl/1.0.2q: 1,794 files, 12.1MB
==> Installing mysql@5.6
==> Downloading https://homebrew.bintray.com/bottles/mysql@5.6-5.6.42.mojave.bottle.1.tar.gz
######################################################################## 100.0%
==> Pouring mysql@5.6-5.6.42.mojave.bottle.1.tar.gz
==> /usr/local/Cellar/mysql@5.6/5.6.42/bin/mysql_install_db --verbose --user=liangyufeng --basedir=/usr/local/Cellar/mysql@5.6/5.6.42 --datadir=/usr/local/var/mysql --tmpdir=/tmp
==> 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 defaultTo connect:mysql -urootmysql@5.6 is keg-only, which means it was not symlinked into /usr/local,
because this is an alternate version of another formula.If you need to have mysql@5.6 first in your PATH run:echo 'export PATH="/usr/local/opt/mysql@5.6/bin:$PATH"' >> ~/.bash_profileFor compilers to find mysql@5.6 you may need to set:export LDFLAGS="-L/usr/local/opt/mysql@5.6/lib"export CPPFLAGS="-I/usr/local/opt/mysql@5.6/include"To have launchd start mysql@5.6 now and restart at login:brew services start mysql@5.6
Or, if you don't want/need a background service you can just run:/usr/local/opt/mysql@5.6/bin/mysql.server start
==> Summary
?  /usr/local/Cellar/mysql@5.6/5.6.42: 342 files, 154.2MB
==> 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/certsand run/usr/local/opt/openssl/bin/c_rehashopenssl 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"' >> ~/.bash_profileFor 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"For pkg-config to find openssl you may need to set:export PKG_CONFIG_PATH="/usr/local/opt/openssl/lib/pkgconfig"==> mysql@5.6
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 defaultTo connect:mysql -urootmysql@5.6 is keg-only, which means it was not symlinked into /usr/local,
because this is an alternate version of another formula.If you need to have mysql@5.6 first in your PATH run:echo 'export PATH="/usr/local/opt/mysql@5.6/bin:$PATH"' >> ~/.bash_profileFor compilers to find mysql@5.6 you may need to set:export LDFLAGS="-L/usr/local/opt/mysql@5.6/lib"export CPPFLAGS="-I/usr/local/opt/mysql@5.6/include"To have launchd start mysql@5.6 now and restart at login:brew services start mysql@5.6
Or, if you don't want/need a background service you can just run:/usr/local/opt/mysql@5.6/bin/mysql.server start
liangyufengdeMacBook-Pro:Cellar liangyufeng$ mysql -uroot
-bash: mysql: command not found
liangyufengdeMacBook-Pro:Cellar liangyufeng$ /usr/local/Cellar/m
mercurial/ mysql@5.6/ 
liangyufengdeMacBook-Pro:Cellar liangyufeng$ /usr/local/Cellar/m
mercurial/ mysql@5.6/ 
liangyufengdeMacBook-Pro:Cellar liangyufeng$ /usr/local/Cellar/mysql\@5.6/5.6.42/
.bottle/       .brew/         bin/           include/       lib/           libexec/       scripts/       share/         sql-bench/     support-files/ 
liangyufengdeMacBook-Pro:Cellar liangyufeng$ /usr/local/Cellar/mysql\@5.6/5.6.42/bin/msql2mysql 
freetype/   gettext/    jpeg/       libogg/     libtiff/    mercurial/  openssl/    pkg-config/ python@2/   sdl/        sdl_mixer/  sphinx-doc/ webp/       
gdbm/       git/        libmikmod/  libpng/     libvorbis/  mysql@5.6/  pcre2/      portmidi/   readline/   sdl_image/  sdl_ttf/    sqlite/     
liangyufengdeMacBook-Pro:Cellar liangyufeng$ /usr/local/Cellar/mysql\@5.6/5.6.42/bin/msql2mysql 
Warning: /usr/local/Cellar/mysql@5.6/5.6.42/bin/msql2mysql is deprecated and will be removed in a future version.^C
liangyufengdeMacBook-Pro:Cellar liangyufeng$ cd /usr/local/Cellar/mysql\@5.6/5.6.42/bin/
liangyufengdeMacBook-Pro:bin liangyufeng$ ls
innochecksum			mysql.server			mysql_fix_extensions		mysql_zap			mysqldump			perror
msql2mysql			mysql_client_test		mysql_install_db		mysqladmin			mysqldumpslow			replace
my_print_defaults		mysql_client_test_embedded	mysql_plugin			mysqlbinlog			mysqlhotcopy			resolve_stack_dump
myisam_ftdump			mysql_config			mysql_secure_installation	mysqlbug			mysqlimport			resolveip
myisamchk			mysql_config_editor		mysql_setpermission		mysqlcheck			mysqlshow
myisamlog			mysql_convert_table_format	mysql_tzinfo_to_sql		mysqld				mysqlslap
myisampack			mysql_embedded			mysql_upgrade			mysqld_multi			mysqltest
mysql				mysql_find_rows			mysql_waitpid			mysqld_safe			mysqltest_embedded
liangyufengdeMacBook-Pro:bin liangyufeng$ ls -lrt
total 253368
-r-xr-xr-x  1 liangyufeng  staff   3157072  9 10 18:23 replace
-r-xr-xr-x  1 liangyufeng  staff     34938  9 10 18:23 mysqlhotcopy
-r-xr-xr-x  1 liangyufeng  staff      7424  9 10 18:23 mysqldumpslow
-r-xr-xr-x  1 liangyufeng  staff      3942  9 10 18:23 mysql_zap
-r-xr-xr-x  1 liangyufeng  staff     17550  9 10 18:23 mysql_setpermission
-r-xr-xr-x  1 liangyufeng  staff     10106  9 10 18:23 mysql_secure_installation
lrwxr-xr-x  1 liangyufeng  staff        27  9 10 18:23 mysql_install_db -> ../scripts/mysql_install_db
-r-xr-xr-x  1 liangyufeng  staff      1331  9 10 18:23 mysql_fix_extensions
-r-xr-xr-x  1 liangyufeng  staff      3374  9 10 18:23 mysql_find_rows
-r-xr-xr-x  1 liangyufeng  staff      4299  9 10 18:23 mysql_convert_table_format
lrwxr-xr-x  1 liangyufeng  staff        29  9 10 18:23 mysql.server -> ../support-files/mysql.server
-r-xr-xr-x  1 liangyufeng  staff   3402280  9 10 18:23 myisamlog
-r-xr-xr-x  1 liangyufeng  staff   3185296  1 11 20:21 innochecksum
-r-xr-xr-x  1 liangyufeng  staff   3180344  1 11 20:21 my_print_defaults
-r-xr-xr-x  1 liangyufeng  staff   3425124  1 11 20:21 myisam_ftdump
-r-xr-xr-x  1 liangyufeng  staff   3519928  1 11 20:21 myisamchk
-r-xr-xr-x  1 liangyufeng  staff   3443204  1 11 20:21 myisampack
-r-xr-xr-x  1 liangyufeng  staff   3470344  1 11 20:21 mysql
-r-xr-xr-x  1 liangyufeng  staff   3761480  1 11 20:21 mysql_client_test
-r-xr-xr-x  1 liangyufeng  staff  11384760  1 11 20:21 mysql_client_test_embedded
-r-xr-xr-x  1 liangyufeng  staff   3374832  1 11 20:21 mysql_config_editor
-r-xr-xr-x  1 liangyufeng  staff  11080428  1 11 20:21 mysql_embedded
-r-xr-xr-x  1 liangyufeng  staff   3189504  1 11 20:21 mysql_plugin
-r-xr-xr-x  1 liangyufeng  staff   3147136  1 11 20:21 mysql_tzinfo_to_sql
-r-xr-xr-x  1 liangyufeng  staff   3484512  1 11 20:21 mysql_upgrade
-r-xr-xr-x  1 liangyufeng  staff   3180128  1 11 20:21 mysql_waitpid
-r-xr-xr-x  1 liangyufeng  staff   3378320  1 11 20:21 mysqladmin
-r-xr-xr-x  1 liangyufeng  staff   3547660  1 11 20:21 mysqlbinlog
-r-xr-xr-x  1 liangyufeng  staff   3373696  1 11 20:21 mysqlcheck
-r-xr-xr-x  1 liangyufeng  staff  11766608  1 11 20:21 mysqld
-r-xr-xr-x  1 liangyufeng  staff   3435992  1 11 20:21 mysqldump
-r-xr-xr-x  1 liangyufeng  staff   3370296  1 11 20:21 mysqlimport
-r-xr-xr-x  1 liangyufeng  staff   3368808  1 11 20:21 mysqlshow
-r-xr-xr-x  1 liangyufeng  staff   3385220  1 11 20:21 mysqlslap
-r-xr-xr-x  1 liangyufeng  staff   3618408  1 11 20:21 mysqltest
-r-xr-xr-x  1 liangyufeng  staff  11203720  1 11 20:21 mysqltest_embedded
-r-xr-xr-x  1 liangyufeng  staff   3284632  1 11 20:21 perror
-r-xr-xr-x  1 liangyufeng  staff   3187036  1 11 20:21 resolve_stack_dump
-r-xr-xr-x  1 liangyufeng  staff   3180348  1 11 20:21 resolveip
-r-xr-xr-x  1 liangyufeng  staff      1569  1 11 20:21 msql2mysql
-r-xr-xr-x  1 liangyufeng  staff      6556  1 11 20:21 mysql_config
-r-xr-xr-x  1 liangyufeng  staff     10928  1 11 20:21 mysqlbug
-r-xr-xr-x  1 liangyufeng  staff     27015  1 11 20:21 mysqld_multi
-r-xr-xr-x  1 liangyufeng  staff     27430  1 11 20:21 mysqld_safe
liangyufengdeMacBook-Pro:bin liangyufeng$ mysqld
-bash: mysqld: command not found
liangyufengdeMacBook-Pro:bin liangyufeng$ ./mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
liangyufengdeMacBook-Pro:bin liangyufeng$ ./mysqld
2019-01-11 20:23:15 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2019-01-11 20:23:15 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2019-01-11 20:23:15 0 [Note] ./mysqld (mysqld 5.6.42) starting as process 62433 ...
2019-01-11 20:23:15 62433 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/var/mysql/ is case insensitive
2019-01-11 20:23:15 62433 [Note] Plugin 'FEDERATED' is disabled.
2019-01-11 20:23:15 62433 [Note] InnoDB: Using atomics to ref count buffer pool pages
2019-01-11 20:23:15 62433 [Note] InnoDB: The InnoDB memory heap is disabled
2019-01-11 20:23:15 62433 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-01-11 20:23:15 62433 [Note] InnoDB: Memory barrier is not used
2019-01-11 20:23:15 62433 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-01-11 20:23:15 62433 [Note] InnoDB: Using CPU crc32 instructions
2019-01-11 20:23:15 62433 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2019-01-11 20:23:15 62433 [Note] InnoDB: Completed initialization of buffer pool
2019-01-11 20:23:15 62433 [Note] InnoDB: Highest supported file format is Barracuda.
2019-01-11 20:23:15 62433 [Note] InnoDB: 128 rollback segment(s) are active.
2019-01-11 20:23:15 62433 [Note] InnoDB: Waiting for purge to start
2019-01-11 20:23:15 62433 [Note] InnoDB: 5.6.42 started; log sequence number 1625987
2019-01-11 20:23:15 62433 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: ab6bd996-159b-11e9-afc2-98bff386c64c.
2019-01-11 20:23:15 62433 [Note] RSA private key file not found: /usr/local/var/mysql//private_key.pem. Some authentication plugins will not work.
2019-01-11 20:23:15 62433 [Note] RSA public key file not found: /usr/local/var/mysql//public_key.pem. Some authentication plugins will not work.
2019-01-11 20:23:15 62433 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
2019-01-11 20:23:15 62433 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
2019-01-11 20:23:15 62433 [Note] Server socket created on IP: '127.0.0.1'.
2019-01-11 20:23:15 62433 [Note] Event Scheduler: Loaded 0 events
2019-01-11 20:23:15 62433 [Note] ./mysqld: ready for connections.
Version: '5.6.42'  socket: '/tmp/mysql.sock'  port: 3306  Homebrew
^C
^C^C^C^C^C^C^C^C
^C^C^C^CKilled: 9
liangyufengdeMacBook-Pro:bin liangyufeng$ 
liangyufengdeMacBook-Pro:bin liangyufeng$ 
liangyufengdeMacBook-Pro:bin liangyufeng$ 
liangyufengdeMacBook-Pro:bin liangyufeng$ which mysqld
liangyufengdeMacBook-Pro:bin liangyufeng$ source ~/.bash_profile 
liangyufengdeMacBook-Pro:bin liangyufeng$ which mysqld
/usr/local/opt/mysql@5.6/bin/mysqld
liangyufengdeMacBook-Pro:bin liangyufeng$ cd
liangyufengdeMacBook-Pro:~ liangyufeng$ 
liangyufengdeMacBook-Pro:~ liangyufeng$ 
liangyufengdeMacBook-Pro:~ liangyufeng$ 
liangyufengdeMacBook-Pro:~ liangyufeng$ 
liangyufengdeMacBook-Pro:~ liangyufeng$ ll
-bash: ll: command not found
liangyufengdeMacBook-Pro:~ liangyufeng$ ls
Applications			Downloads			Movies				Public				Virtual Machines.localized	iCloud Drive(归档)
Desktop				Kingsoft			Music				PycharmProjects			VirtualBox VMs			test
Documents			Library				Pictures			VMware				day33上课便签.txt		venv
liangyufengdeMacBook-Pro:~ liangyufeng$ nohup mysqld &
[1] 62603
liangyufengdeMacBook-Pro:~ liangyufeng$ appending output to nohup.outliangyufengdeMacBook-Pro:~ liangyufeng$ ps -ef|grep mysqld501 62603 25300   0  9:16下午 ttys000    0:00.47 mysqld501 62605 25300   0  9:17下午 ttys000    0:00.00 grep mysqld
liangyufengdeMacBook-Pro:~ liangyufeng$ ps -ef|grep mysqld501 62603 25300   0  9:16下午 ttys000    0:00.47 mysqld501 62608 25300   0  9:17下午 ttys000    0:00.00 grep mysqld501 62606 62055   0  9:17下午 ttys001    0:00.40 mysqld
liangyufengdeMacBook-Pro:~ liangyufeng$ kill -9 62606
liangyufengdeMacBook-Pro:~ liangyufeng$ 

  之后打开的一个终端窗口:

Last login: Fri Jan 11 20:11:14 on ttys001
liangyufengdeMacBook-Pro:~ liangyufeng$ brew info mysql
xcrun: error: invalid active developer path (/Library/Developer/CommandLineTools), missing xcrun at: /Library/Developer/CommandLineTools/usr/bin/xcrun
mysql: stable 8.0.13 (bottled)
Open source relational database management system
https://dev.mysql.com/doc/refman/8.0/en/
Conflicts with:mariadb (because mysql, mariadb, and percona install the same binaries.)mariadb-connector-c (because both install plugins)mysql-cluster (because mysql, mariadb, and percona install the same binaries.)mysql-connector-c (because both install MySQL client libraries)percona-server (because mysql, mariadb, and percona install the same binaries.)
Not installed
From: https://github.com/Homebrew/homebrew-core/blob/master/Formula/mysql.rb
==> Dependencies
Build: cmake ✘
Required: openssl ✔
==> Requirements
Required: macOS >= 10.10 ✔
==> Caveats
We've installed your MySQL database without a root password. To secure it run:mysql_secure_installationMySQL is configured to only allow connections from localhost by defaultTo connect run:mysql -urootTo have launchd start mysql now and restart at login:brew services start mysql
Or, if you don't want/need a background service you can just run:mysql.server start
==> Analytics
install: 63,161 (30 days), 183,957 (90 days), 888,341 (365 days)
install_on_request: 57,982 (30 days), 172,668 (90 days), 790,136 (365 days)
build_error: 0 (30 days)
liangyufengdeMacBook-Pro:~ liangyufeng$ brew search mysql
xcrun: error: invalid active developer path (/Library/Developer/CommandLineTools), missing xcrun at: /Library/Developer/CommandLineTools/usr/bin/xcrun
==> Formulae
automysqlbackup              mysql++                      mysql-cluster                mysql-connector-c++          mysql-search-replace         mysql@5.5                    mysql@5.7
mysql                        mysql-client                 mysql-connector-c            mysql-sandbox                mysql-utilities              mysql@5.6                    mysqltuner==> Casks
homebrew/cask/mysql-connector-python    homebrew/cask/mysql-shell               homebrew/cask/mysql-utilities           homebrew/cask/navicat-for-mysql         homebrew/cask/sqlpro-for-mysql
liangyufengdeMacBook-Pro:~ liangyufeng$ /usr/local/Cellar/
freetype/   gettext/    jpeg/       libogg/     libtiff/    mercurial/  openssl/    pkg-config/ python@2/   sdl/        sdl_mixer/  sphinx-doc/ webp/       
gdbm/       git/        libmikmod/  libpng/     libvorbis/  mysql@5.6/  pcre2/      portmidi/   readline/   sdl_image/  sdl_ttf/    sqlite/     
liangyufengdeMacBook-Pro:~ liangyufeng$ /usr/local/Cellar/mysql\@5.6/5.6.42/bin/mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.42 HomebrewCopyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql> 
mysql> 
mysql> 
mysql> 
mysql> 
mysql> 
mysql> exit
Bye
liangyufengdeMacBook-Pro:~ liangyufeng$ /usr/local/Cellar/mysql\@5.6/5.6.42/bin/mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.6.42 HomebrewCopyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql> exit
Bye
liangyufengdeMacBook-Pro:~ liangyufeng$ /usr/local/Cellar/mysql\@5.6/5.6.42/bin/mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.6.42 HomebrewCopyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql> exit
Bye
liangyufengdeMacBook-Pro:~ liangyufeng$ echo "/usr/local/Cellar/mysql\@5.6/5.6.42/bin/mysql" >> ~/.bash_profile 
liangyufengdeMacBook-Pro:~ liangyufeng$ cat ~/.bash_profile# Setting PATH for Python 3.6
# The original version is saved in .bash_profile.pysave
PATH="/Library/Frameworks/Python.framework/Versions/3.6/bin:${PATH}"
export PATH
/usr/local/Cellar/mysql\@5.6/5.6.42/bin/mysql
liangyufengdeMacBook-Pro:~ liangyufeng$ vi ~/.bash_profile
liangyufengdeMacBook-Pro:~ liangyufeng$ source ~/.bash_profile
liangyufengdeMacBook-Pro:~ liangyufeng$ mysql
-bash: mysql: command not found
liangyufengdeMacBook-Pro:~ liangyufeng$ vi ~/.bash_profile
liangyufengdeMacBook-Pro:~ liangyufeng$ cat ~/.
./                   .CFUserTextEncoding  .Trash/              .bash_profile        .config/             .idlerc/             .mysql_history       .sogouinput/         .viminfo
../                  .DS_Store            .bash_history        .bash_sessions/      .gitconfig           .kingsoft/           .python_history      .ssh/                .vscode/
liangyufengdeMacBook-Pro:~ liangyufeng$ echo 'export PATH="/usr/local/opt/openssl/bin:$PATH"' >> ~/.bash_profile
liangyufengdeMacBook-Pro:~ liangyufeng$ pwd
/Users/liangyufeng
liangyufengdeMacBook-Pro:~ liangyufeng$ echo 'export PATH="/usr/local/Cellar/mysql\@5.6/5.6.42/bin/mysql:$PATH"' >> ~/.bash_profile
liangyufengdeMacBook-Pro:~ liangyufeng$ source ~/.bash_profile 
liangyufengdeMacBook-Pro:~ liangyufeng$ mysql
-bash: mysql: command not found
liangyufengdeMacBook-Pro:~ liangyufeng$ 
liangyufengdeMacBook-Pro:~ liangyufeng$ 
liangyufengdeMacBook-Pro:~ liangyufeng$ 
liangyufengdeMacBook-Pro:~ liangyufeng$ cat ~/.bash_profile # Setting PATH for Python 3.6
# The original version is saved in .bash_profile.pysave
PATH="/Library/Frameworks/Python.framework/Versions/3.6/bin:${PATH}":/usr/local/Cellar/mysql\@5.6/5.6.42/bin/mysql
export PATH
export PATH="/usr/local/Cellar/mysql\@5.6/5.6.42/bin/mysql:$PATH"
liangyufengdeMacBook-Pro:~ liangyufeng$ which mysql
liangyufengdeMacBook-Pro:~ liangyufeng$ vim ~/.bash_profile 
liangyufengdeMacBook-Pro:~ liangyufeng$ source ~/.bash_profile 
liangyufengdeMacBook-Pro:~ liangyufeng$ mysql
-bash: mysql: command not found
liangyufengdeMacBook-Pro:~ liangyufeng$ 
liangyufengdeMacBook-Pro:~ liangyufeng$ 
liangyufengdeMacBook-Pro:~ liangyufeng$ 
liangyufengdeMacBook-Pro:~ liangyufeng$ 
liangyufengdeMacBook-Pro:~ liangyufeng$ 
liangyufengdeMacBook-Pro:~ liangyufeng$ 
liangyufengdeMacBook-Pro:~ liangyufeng$ 
liangyufengdeMacBook-Pro:~ liangyufeng$ 
liangyufengdeMacBook-Pro:~ liangyufeng$ 
liangyufengdeMacBook-Pro:~ liangyufeng$ 
liangyufengdeMacBook-Pro:~ liangyufeng$ 
liangyufengdeMacBook-Pro:~ liangyufeng$ 
liangyufengdeMacBook-Pro:~ liangyufeng$ 
liangyufengdeMacBook-Pro:~ liangyufeng$ echo 'export PATH="/usr/local/opt/mysql@5.6/bin:$PATH"' >> ~/.bash_profile
liangyufengdeMacBook-Pro:~ liangyufeng$ vi ~/.bash_profile
liangyufengdeMacBook-Pro:~ liangyufeng$ source ~/.bash_profile 
liangyufengdeMacBook-Pro:~ liangyufeng$ mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.6.42 HomebrewCopyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql> exit
Bye
liangyufengdeMacBook-Pro:~ liangyufeng$ ps -ef|grep mysql501 62433 25300   0  8:23下午 ttys000    0:00.92 ./mysqld501 62593 62055   0  9:14下午 ttys001    0:00.00 grep mysql
liangyufengdeMacBook-Pro:~ liangyufeng$ kill -9 62433
liangyufengdeMacBook-Pro:~ liangyufeng$ which mysql
/usr/local/opt/mysql@5.6/bin/mysql
liangyufengdeMacBook-Pro:~ liangyufeng$ mysqld
2019-01-11 21:17:22 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2019-01-11 21:17:22 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2019-01-11 21:17:22 0 [Note] mysqld (mysqld 5.6.42) starting as process 62606 ...
2019-01-11 21:17:22 62606 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/var/mysql/ is case insensitive
2019-01-11 21:17:22 62606 [Note] Plugin 'FEDERATED' is disabled.
2019-01-11 21:17:22 62606 [Note] InnoDB: Using atomics to ref count buffer pool pages
2019-01-11 21:17:22 62606 [Note] InnoDB: The InnoDB memory heap is disabled
2019-01-11 21:17:22 62606 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-01-11 21:17:22 62606 [Note] InnoDB: Memory barrier is not used
2019-01-11 21:17:22 62606 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-01-11 21:17:22 62606 [Note] InnoDB: Using CPU crc32 instructions
2019-01-11 21:17:22 62606 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2019-01-11 21:17:22 62606 [Note] InnoDB: Completed initialization of buffer pool
2019-01-11 21:17:22 62606 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2019-01-11 21:17:22 62606 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2019-01-11 21:17:22 62606 [Note] InnoDB: Retrying to lock the first data file
^C2019-01-11 21:17:23 62606 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2019-01-11 21:17:23 62606 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
^C^C^C2019-01-11 21:17:24 62606 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2019-01-11 21:17:24 62606 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2019-01-11 21:17:25 62606 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2019-01-11 21:17:25 62606 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
^C^C2019-01-11 21:17:26 62606 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2019-01-11 21:17:26 62606 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
^C2019-01-11 21:17:27 62606 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2019-01-11 21:17:27 62606 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2019-01-11 21:17:28 62606 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2019-01-11 21:17:28 62606 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2019-01-11 21:17:29 62606 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2019-01-11 21:17:29 62606 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2019-01-11 21:17:30 62606 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2019-01-11 21:17:30 62606 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2019-01-11 21:17:31 62606 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2019-01-11 21:17:31 62606 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2019-01-11 21:17:32 62606 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2019-01-11 21:17:32 62606 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2019-01-11 21:17:33 62606 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2019-01-11 21:17:33 62606 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2019-01-11 21:17:34 62606 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2019-01-11 21:17:34 62606 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2019-01-11 21:17:35 62606 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2019-01-11 21:17:35 62606 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2019-01-11 21:17:36 62606 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2019-01-11 21:17:36 62606 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2019-01-11 21:17:37 62606 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2019-01-11 21:17:37 62606 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2019-01-11 21:17:38 62606 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2019-01-11 21:17:38 62606 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2019-01-11 21:17:39 62606 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2019-01-11 21:17:39 62606 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2019-01-11 21:17:40 62606 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2019-01-11 21:17:40 62606 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2019-01-11 21:17:41 62606 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2019-01-11 21:17:41 62606 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2019-01-11 21:17:42 62606 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35
2019-01-11 21:17:42 62606 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
Killed: 9
liangyufengdeMacBook-Pro:~ liangyufeng$ 
liangyufengdeMacBook-Pro:~ liangyufeng$ mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.42 HomebrewCopyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| test               |
+--------------------+
2 rows in set (0.00 sec)mysql> use test;
Database changed
mysql> show tables;
Empty set (0.00 sec)mysql> exit
Bye
liangyufengdeMacBook-Pro:~ liangyufeng$ 

  使用下面的命令行操作来打开数据库:(如果电脑不关机就没必要输入这句话了,只需要每次电脑关机重启的时候才需要输入一次.MySQL用完也没必要关闭.)   nohup mysqld &

liangyufengdeMacBook-Pro:~ liangyufeng$ nohup mysqld &

  

 

转载于:https://www.cnblogs.com/liangxiaoji/p/10257641.html

查看全文
如若内容造成侵权/违法违规/事实不符,请联系编程学习网邮箱:809451989@qq.com进行投诉反馈,一经查实,立即删除!

相关文章

  1. 汇编:查找匹配字符串

    功能要求 程序接收用户键入的一个关键字以及一个句子。如果句子中不包含关键字则显示‘No match!’;如果句子中包含关键字则显示‘Match’,且把该字在句子中的位置用十六进制数显示出来。 assume cs:code, ds:data, ss:stack data segmenttips db The location of the keywor…...

    2024/4/30 13:30:04
  2. 青岛青岛本溪哪一家做双眼皮最好

    ...

    2024/4/21 16:13:06
  3. angular知识点--依赖注入

    碎碎念:知识点梳理归纳,如果有什么不对的感谢大家指正一起学习! 一.、 什么是依赖注入模式及使用依赖注入的好处 它是一种编程模式,可以让类从外部源中获得它的依赖,而不必亲自创建它们。 使用依赖注入的好处&#xff…...

    2024/4/21 16:13:05
  4. angular知识点--动态组件

    动态组件 碎碎念:都是一些自己在学习过程中的一点体会,如果有什么不对的感谢大家指正一起学习! 实现动态加载组件,最重要的3个部分:viewchild,viewContainerRef , componentFactoryResolver ViewChild&am…...

    2024/4/21 16:13:03
  5. 做双眼皮睫毛漏白

    ...

    2024/4/21 16:13:02
  6. 南昌那个整形医院割双眼皮好

    ...

    2024/4/21 16:13:01
  7. SparkSQL(6):外部数据源

    一、总括1.参考官网:http://spark.apache.org/docs/2.1.0/sql-programming-guide.html#data-sources2.SparkSQL支持多种数据源,这个部分主要讲了使用Spark加载和保存数据源。然后,讲解内置数据源的特定选项。3.数据源分类:(1)parquet数据(2)hive表(3)jdbc连接其他数据…...

    2024/4/20 14:31:01
  8. Angular Day4 生命周期

    学习Angular的时候总是搞不清楚ngOnInit和constructor的区别。来说明一下。 ** ngOnInit和constructor ** //一个组件的 ts文件中: import { Component, OnInit, Input, Output, EventEmitter } from angular/core;export interface TopMenu {title: string;link…...

    2024/4/20 14:30:59
  9. 深度解析ES6通过WeakMap解决内存泄漏问题

    本篇文章主要介绍了详解ES6通过WeakMap解决内存泄漏问题,写的十分的全面细致,具有一定的参考价值,对此有需要的朋友可以参考学习下。如有不足之处,欢迎批评指正。 #一、Map 1.定义 Map对象保存键值对,类似于数据结构字…...

    2024/5/2 23:17:59
  10. 孔繁荣割双眼皮失败父母不管我了

    ...

    2024/4/20 14:30:57
  11. 埋线双眼皮自己把线拽出来了

    ...

    2024/5/5 20:46:07
  12. 双眼皮割完流脓水

    ...

    2024/4/21 16:13:00
  13. 双眼皮伤口发炎症状

    ...

    2024/4/21 16:12:59
  14. 双眼皮 感染

    ...

    2024/4/21 16:12:57
  15. 根据数组中对象的某一属性排序

    根据数组中对象的某一属性排序 var newArray [{name: "aaa",value: 0 }, {name: "ddd",value: 3 }, {name: "bbb",value: 1 }, {name: "eee",value: 4 }, {name: "ccc",value: 2 }]; function compare(property) {return …...

    2024/4/21 16:12:57
  16. 数组中key(或者某个字段)相同的对象组成新的数组

    代码 var arr[{id: 3, username: "test", companyName: "农商行"}, {id: 4, username: "张三", companyName: "动检所"}, {id: 2, username: "test2", companyName: "农商行"}, ]var obj {};arr.forEach(func…...

    2024/4/21 16:12:55
  17. 用reduce对对象数组指定属性进行累加

    遇到累加,第一个反应就是用reduce函数,以前没怎么用过,网上很多都是简单的数组进行累加,对象数组的没有看到,就专门记录下。 // body是个对象数组,需求是对对象上的itemsCount属性进行累加 let count 0; …...

    2024/4/21 16:12:55
  18. 双眼皮 坑

    ...

    2024/4/21 16:12:53
  19. 双眼皮贴松了能恢复吗

    ...

    2024/4/29 4:01:53
  20. 贴双眼皮松弛恢复

    ...

    2024/4/21 16:12:52

最新文章

  1. 车载诊断技术 --- Service 22读取DID怎么会导致ECU不在线

    车载诊断技术 — Service 22读取DID怎么会导致ECU不在线 我是穿拖鞋的汉子,魔都中坚持长期主义的汽车电子工程师。 老规矩,分享一段喜欢的文字,避免自己成为高知识低文化的工程师: 屏蔽力是信息过载时代一个人的特殊竞争力,任何消耗你的人和事,多看一眼都是你的不对。非…...

    2024/5/5 22:29:43
  2. 梯度消失和梯度爆炸的一些处理方法

    在这里是记录一下梯度消失或梯度爆炸的一些处理技巧。全当学习总结了如有错误还请留言,在此感激不尽。 权重和梯度的更新公式如下: w w − η ⋅ ∇ w w w - \eta \cdot \nabla w ww−η⋅∇w 个人通俗的理解梯度消失就是网络模型在反向求导的时候出…...

    2024/3/20 10:50:27
  3. axios拦截器:每次请求自动带上 token

    Step 1:创建Axios实例并添加拦截器 在你的Vue项目中,一般我们会先导入axios,然后创建一个axios实例。这样做是为了方便统一管理和配置。 import axios from axios; // 引入axios// 创建一个axios实例 const service axios.create();// 添加请…...

    2024/5/4 22:20:25
  4. 【C++】map set 底层刨析

    文章目录 1. 红黑树的迭代器2. 改造红黑树3. map 的模拟实现4. set 的模拟实现 在 C STL 库中,map 与 set 的底层为红黑树,那么在不写冗余代码的情况下使用红黑树同时实现 map 与 set 便是本文的重点。 1. 红黑树的迭代器 迭代器的好处是可以方便遍历&…...

    2024/5/5 8:33:40
  5. 【外汇早评】美通胀数据走低,美元调整

    原标题:【外汇早评】美通胀数据走低,美元调整昨日美国方面公布了新一期的核心PCE物价指数数据,同比增长1.6%,低于前值和预期值的1.7%,距离美联储的通胀目标2%继续走低,通胀压力较低,且此前美国一季度GDP初值中的消费部分下滑明显,因此市场对美联储后续更可能降息的政策…...

    2024/5/4 23:54:56
  6. 【原油贵金属周评】原油多头拥挤,价格调整

    原标题:【原油贵金属周评】原油多头拥挤,价格调整本周国际劳动节,我们喜迎四天假期,但是整个金融市场确实流动性充沛,大事频发,各个商品波动剧烈。美国方面,在本周四凌晨公布5月份的利率决议和新闻发布会,维持联邦基金利率在2.25%-2.50%不变,符合市场预期。同时美联储…...

    2024/5/4 23:54:56
  7. 【外汇周评】靓丽非农不及疲软通胀影响

    原标题:【外汇周评】靓丽非农不及疲软通胀影响在刚结束的周五,美国方面公布了新一期的非农就业数据,大幅好于前值和预期,新增就业重新回到20万以上。具体数据: 美国4月非农就业人口变动 26.3万人,预期 19万人,前值 19.6万人。 美国4月失业率 3.6%,预期 3.8%,前值 3…...

    2024/5/4 23:54:56
  8. 【原油贵金属早评】库存继续增加,油价收跌

    原标题:【原油贵金属早评】库存继续增加,油价收跌周三清晨公布美国当周API原油库存数据,上周原油库存增加281万桶至4.692亿桶,增幅超过预期的74.4万桶。且有消息人士称,沙特阿美据悉将于6月向亚洲炼油厂额外出售更多原油,印度炼油商预计将每日获得至多20万桶的额外原油供…...

    2024/5/4 23:55:17
  9. 【外汇早评】日本央行会议纪要不改日元强势

    原标题:【外汇早评】日本央行会议纪要不改日元强势近两日日元大幅走强与近期市场风险情绪上升,避险资金回流日元有关,也与前一段时间的美日贸易谈判给日本缓冲期,日本方面对汇率问题也避免继续贬值有关。虽然今日早间日本央行公布的利率会议纪要仍然是支持宽松政策,但这符…...

    2024/5/4 23:54:56
  10. 【原油贵金属早评】欧佩克稳定市场,填补伊朗问题的影响

    原标题:【原油贵金属早评】欧佩克稳定市场,填补伊朗问题的影响近日伊朗局势升温,导致市场担忧影响原油供给,油价试图反弹。此时OPEC表态稳定市场。据消息人士透露,沙特6月石油出口料将低于700万桶/日,沙特已经收到石油消费国提出的6月份扩大出口的“适度要求”,沙特将满…...

    2024/5/4 23:55:05
  11. 【外汇早评】美欲与伊朗重谈协议

    原标题:【外汇早评】美欲与伊朗重谈协议美国对伊朗的制裁遭到伊朗的抗议,昨日伊朗方面提出将部分退出伊核协议。而此行为又遭到欧洲方面对伊朗的谴责和警告,伊朗外长昨日回应称,欧洲国家履行它们的义务,伊核协议就能保证存续。据传闻伊朗的导弹已经对准了以色列和美国的航…...

    2024/5/4 23:54:56
  12. 【原油贵金属早评】波动率飙升,市场情绪动荡

    原标题:【原油贵金属早评】波动率飙升,市场情绪动荡因中美贸易谈判不安情绪影响,金融市场各资产品种出现明显的波动。随着美国与中方开启第十一轮谈判之际,美国按照既定计划向中国2000亿商品征收25%的关税,市场情绪有所平复,已经开始接受这一事实。虽然波动率-恐慌指数VI…...

    2024/5/4 23:55:16
  13. 【原油贵金属周评】伊朗局势升温,黄金多头跃跃欲试

    原标题:【原油贵金属周评】伊朗局势升温,黄金多头跃跃欲试美国和伊朗的局势继续升温,市场风险情绪上升,避险黄金有向上突破阻力的迹象。原油方面稍显平稳,近期美国和OPEC加大供给及市场需求回落的影响,伊朗局势并未推升油价走强。近期中美贸易谈判摩擦再度升级,美国对中…...

    2024/5/4 23:54:56
  14. 【原油贵金属早评】市场情绪继续恶化,黄金上破

    原标题:【原油贵金属早评】市场情绪继续恶化,黄金上破周初中国针对于美国加征关税的进行的反制措施引发市场情绪的大幅波动,人民币汇率出现大幅的贬值动能,金融市场受到非常明显的冲击。尤其是波动率起来之后,对于股市的表现尤其不安。隔夜美国股市出现明显的下行走势,这…...

    2024/5/4 18:20:48
  15. 【外汇早评】美伊僵持,风险情绪继续升温

    原标题:【外汇早评】美伊僵持,风险情绪继续升温昨日沙特两艘油轮再次发生爆炸事件,导致波斯湾局势进一步恶化,市场担忧美伊可能会出现摩擦生火,避险品种获得支撑,黄金和日元大幅走强。美指受中美贸易问题影响而在低位震荡。继5月12日,四艘商船在阿联酋领海附近的阿曼湾、…...

    2024/5/4 23:54:56
  16. 【原油贵金属早评】贸易冲突导致需求低迷,油价弱势

    原标题:【原油贵金属早评】贸易冲突导致需求低迷,油价弱势近日虽然伊朗局势升温,中东地区几起油船被袭击事件影响,但油价并未走高,而是出于调整结构中。由于市场预期局势失控的可能性较低,而中美贸易问题导致的全球经济衰退风险更大,需求会持续低迷,因此油价调整压力较…...

    2024/5/4 23:55:17
  17. 氧生福地 玩美北湖(上)——为时光守候两千年

    原标题:氧生福地 玩美北湖(上)——为时光守候两千年一次说走就走的旅行,只有一张高铁票的距离~ 所以,湖南郴州,我来了~ 从广州南站出发,一个半小时就到达郴州西站了。在动车上,同时改票的南风兄和我居然被分到了一个车厢,所以一路非常愉快地聊了过来。 挺好,最起…...

    2024/5/4 23:55:06
  18. 氧生福地 玩美北湖(中)——永春梯田里的美与鲜

    原标题:氧生福地 玩美北湖(中)——永春梯田里的美与鲜一觉醒来,因为大家太爱“美”照,在柳毅山庄去寻找龙女而错过了早餐时间。近十点,向导坏坏还是带着饥肠辘辘的我们去吃郴州最富有盛名的“鱼头粉”。说这是“十二分推荐”,到郴州必吃的美食之一。 哇塞!那个味美香甜…...

    2024/5/4 23:54:56
  19. 氧生福地 玩美北湖(下)——奔跑吧骚年!

    原标题:氧生福地 玩美北湖(下)——奔跑吧骚年!让我们红尘做伴 活得潇潇洒洒 策马奔腾共享人世繁华 对酒当歌唱出心中喜悦 轰轰烈烈把握青春年华 让我们红尘做伴 活得潇潇洒洒 策马奔腾共享人世繁华 对酒当歌唱出心中喜悦 轰轰烈烈把握青春年华 啊……啊……啊 两…...

    2024/5/4 23:55:06
  20. 扒开伪装医用面膜,翻六倍价格宰客,小姐姐注意了!

    原标题:扒开伪装医用面膜,翻六倍价格宰客,小姐姐注意了!扒开伪装医用面膜,翻六倍价格宰客!当行业里的某一品项火爆了,就会有很多商家蹭热度,装逼忽悠,最近火爆朋友圈的医用面膜,被沾上了污点,到底怎么回事呢? “比普通面膜安全、效果好!痘痘、痘印、敏感肌都能用…...

    2024/5/5 8:13:33
  21. 「发现」铁皮石斛仙草之神奇功效用于医用面膜

    原标题:「发现」铁皮石斛仙草之神奇功效用于医用面膜丽彦妆铁皮石斛医用面膜|石斛多糖无菌修护补水贴19大优势: 1、铁皮石斛:自唐宋以来,一直被列为皇室贡品,铁皮石斛生于海拔1600米的悬崖峭壁之上,繁殖力差,产量极低,所以古代仅供皇室、贵族享用 2、铁皮石斛自古民间…...

    2024/5/4 23:55:16
  22. 丽彦妆\医用面膜\冷敷贴轻奢医学护肤引导者

    原标题:丽彦妆\医用面膜\冷敷贴轻奢医学护肤引导者【公司简介】 广州华彬企业隶属香港华彬集团有限公司,专注美业21年,其旗下品牌: 「圣茵美」私密荷尔蒙抗衰,产后修复 「圣仪轩」私密荷尔蒙抗衰,产后修复 「花茵莳」私密荷尔蒙抗衰,产后修复 「丽彦妆」专注医学护…...

    2024/5/4 23:54:58
  23. 广州械字号面膜生产厂家OEM/ODM4项须知!

    原标题:广州械字号面膜生产厂家OEM/ODM4项须知!广州械字号面膜生产厂家OEM/ODM流程及注意事项解读: 械字号医用面膜,其实在我国并没有严格的定义,通常我们说的医美面膜指的应该是一种「医用敷料」,也就是说,医用面膜其实算作「医疗器械」的一种,又称「医用冷敷贴」。 …...

    2024/5/4 23:55:01
  24. 械字号医用眼膜缓解用眼过度到底有无作用?

    原标题:械字号医用眼膜缓解用眼过度到底有无作用?医用眼膜/械字号眼膜/医用冷敷眼贴 凝胶层为亲水高分子材料,含70%以上的水分。体表皮肤温度传导到本产品的凝胶层,热量被凝胶内水分子吸收,通过水分的蒸发带走大量的热量,可迅速地降低体表皮肤局部温度,减轻局部皮肤的灼…...

    2024/5/4 23:54:56
  25. 配置失败还原请勿关闭计算机,电脑开机屏幕上面显示,配置失败还原更改 请勿关闭计算机 开不了机 这个问题怎么办...

    解析如下:1、长按电脑电源键直至关机,然后再按一次电源健重启电脑,按F8健进入安全模式2、安全模式下进入Windows系统桌面后,按住“winR”打开运行窗口,输入“services.msc”打开服务设置3、在服务界面,选中…...

    2022/11/19 21:17:18
  26. 错误使用 reshape要执行 RESHAPE,请勿更改元素数目。

    %读入6幅图像(每一幅图像的大小是564*564) f1 imread(WashingtonDC_Band1_564.tif); subplot(3,2,1),imshow(f1); f2 imread(WashingtonDC_Band2_564.tif); subplot(3,2,2),imshow(f2); f3 imread(WashingtonDC_Band3_564.tif); subplot(3,2,3),imsho…...

    2022/11/19 21:17:16
  27. 配置 已完成 请勿关闭计算机,win7系统关机提示“配置Windows Update已完成30%请勿关闭计算机...

    win7系统关机提示“配置Windows Update已完成30%请勿关闭计算机”问题的解决方法在win7系统关机时如果有升级系统的或者其他需要会直接进入一个 等待界面,在等待界面中我们需要等待操作结束才能关机,虽然这比较麻烦,但是对系统进行配置和升级…...

    2022/11/19 21:17:15
  28. 台式电脑显示配置100%请勿关闭计算机,“准备配置windows 请勿关闭计算机”的解决方法...

    有不少用户在重装Win7系统或更新系统后会遇到“准备配置windows,请勿关闭计算机”的提示,要过很久才能进入系统,有的用户甚至几个小时也无法进入,下面就教大家这个问题的解决方法。第一种方法:我们首先在左下角的“开始…...

    2022/11/19 21:17:14
  29. win7 正在配置 请勿关闭计算机,怎么办Win7开机显示正在配置Windows Update请勿关机...

    置信有很多用户都跟小编一样遇到过这样的问题,电脑时发现开机屏幕显现“正在配置Windows Update,请勿关机”(如下图所示),而且还需求等大约5分钟才干进入系统。这是怎样回事呢?一切都是正常操作的,为什么开时机呈现“正…...

    2022/11/19 21:17:13
  30. 准备配置windows 请勿关闭计算机 蓝屏,Win7开机总是出现提示“配置Windows请勿关机”...

    Win7系统开机启动时总是出现“配置Windows请勿关机”的提示,没过几秒后电脑自动重启,每次开机都这样无法进入系统,此时碰到这种现象的用户就可以使用以下5种方法解决问题。方法一:开机按下F8,在出现的Windows高级启动选…...

    2022/11/19 21:17:12
  31. 准备windows请勿关闭计算机要多久,windows10系统提示正在准备windows请勿关闭计算机怎么办...

    有不少windows10系统用户反映说碰到这样一个情况,就是电脑提示正在准备windows请勿关闭计算机,碰到这样的问题该怎么解决呢,现在小编就给大家分享一下windows10系统提示正在准备windows请勿关闭计算机的具体第一种方法:1、2、依次…...

    2022/11/19 21:17:11
  32. 配置 已完成 请勿关闭计算机,win7系统关机提示“配置Windows Update已完成30%请勿关闭计算机”的解决方法...

    今天和大家分享一下win7系统重装了Win7旗舰版系统后,每次关机的时候桌面上都会显示一个“配置Windows Update的界面,提示请勿关闭计算机”,每次停留好几分钟才能正常关机,导致什么情况引起的呢?出现配置Windows Update…...

    2022/11/19 21:17:10
  33. 电脑桌面一直是清理请关闭计算机,windows7一直卡在清理 请勿关闭计算机-win7清理请勿关机,win7配置更新35%不动...

    只能是等着,别无他法。说是卡着如果你看硬盘灯应该在读写。如果从 Win 10 无法正常回滚,只能是考虑备份数据后重装系统了。解决来方案一:管理员运行cmd:net stop WuAuServcd %windir%ren SoftwareDistribution SDoldnet start WuA…...

    2022/11/19 21:17:09
  34. 计算机配置更新不起,电脑提示“配置Windows Update请勿关闭计算机”怎么办?

    原标题:电脑提示“配置Windows Update请勿关闭计算机”怎么办?win7系统中在开机与关闭的时候总是显示“配置windows update请勿关闭计算机”相信有不少朋友都曾遇到过一次两次还能忍但经常遇到就叫人感到心烦了遇到这种问题怎么办呢?一般的方…...

    2022/11/19 21:17:08
  35. 计算机正在配置无法关机,关机提示 windows7 正在配置windows 请勿关闭计算机 ,然后等了一晚上也没有关掉。现在电脑无法正常关机...

    关机提示 windows7 正在配置windows 请勿关闭计算机 ,然后等了一晚上也没有关掉。现在电脑无法正常关机以下文字资料是由(历史新知网www.lishixinzhi.com)小编为大家搜集整理后发布的内容,让我们赶快一起来看一下吧!关机提示 windows7 正在配…...

    2022/11/19 21:17:05
  36. 钉钉提示请勿通过开发者调试模式_钉钉请勿通过开发者调试模式是真的吗好不好用...

    钉钉请勿通过开发者调试模式是真的吗好不好用 更新时间:2020-04-20 22:24:19 浏览次数:729次 区域: 南阳 > 卧龙 列举网提醒您:为保障您的权益,请不要提前支付任何费用! 虚拟位置外设器!!轨迹模拟&虚拟位置外设神器 专业用于:钉钉,外勤365,红圈通,企业微信和…...

    2022/11/19 21:17:05
  37. 配置失败还原请勿关闭计算机怎么办,win7系统出现“配置windows update失败 还原更改 请勿关闭计算机”,长时间没反应,无法进入系统的解决方案...

    前几天班里有位学生电脑(windows 7系统)出问题了,具体表现是开机时一直停留在“配置windows update失败 还原更改 请勿关闭计算机”这个界面,长时间没反应,无法进入系统。这个问题原来帮其他同学也解决过,网上搜了不少资料&#x…...

    2022/11/19 21:17:04
  38. 一个电脑无法关闭计算机你应该怎么办,电脑显示“清理请勿关闭计算机”怎么办?...

    本文为你提供了3个有效解决电脑显示“清理请勿关闭计算机”问题的方法,并在最后教给你1种保护系统安全的好方法,一起来看看!电脑出现“清理请勿关闭计算机”在Windows 7(SP1)和Windows Server 2008 R2 SP1中,添加了1个新功能在“磁…...

    2022/11/19 21:17:03
  39. 请勿关闭计算机还原更改要多久,电脑显示:配置windows更新失败,正在还原更改,请勿关闭计算机怎么办...

    许多用户在长期不使用电脑的时候,开启电脑发现电脑显示:配置windows更新失败,正在还原更改,请勿关闭计算机。。.这要怎么办呢?下面小编就带着大家一起看看吧!如果能够正常进入系统,建议您暂时移…...

    2022/11/19 21:17:02
  40. 还原更改请勿关闭计算机 要多久,配置windows update失败 还原更改 请勿关闭计算机,电脑开机后一直显示以...

    配置windows update失败 还原更改 请勿关闭计算机,电脑开机后一直显示以以下文字资料是由(历史新知网www.lishixinzhi.com)小编为大家搜集整理后发布的内容,让我们赶快一起来看一下吧!配置windows update失败 还原更改 请勿关闭计算机&#x…...

    2022/11/19 21:17:01
  41. 电脑配置中请勿关闭计算机怎么办,准备配置windows请勿关闭计算机一直显示怎么办【图解】...

    不知道大家有没有遇到过这样的一个问题,就是我们的win7系统在关机的时候,总是喜欢显示“准备配置windows,请勿关机”这样的一个页面,没有什么大碍,但是如果一直等着的话就要两个小时甚至更久都关不了机,非常…...

    2022/11/19 21:17:00
  42. 正在准备配置请勿关闭计算机,正在准备配置windows请勿关闭计算机时间长了解决教程...

    当电脑出现正在准备配置windows请勿关闭计算机时,一般是您正对windows进行升级,但是这个要是长时间没有反应,我们不能再傻等下去了。可能是电脑出了别的问题了,来看看教程的说法。正在准备配置windows请勿关闭计算机时间长了方法一…...

    2022/11/19 21:16:59
  43. 配置失败还原请勿关闭计算机,配置Windows Update失败,还原更改请勿关闭计算机...

    我们使用电脑的过程中有时会遇到这种情况,当我们打开电脑之后,发现一直停留在一个界面:“配置Windows Update失败,还原更改请勿关闭计算机”,等了许久还是无法进入系统。如果我们遇到此类问题应该如何解决呢&#xff0…...

    2022/11/19 21:16:58
  44. 如何在iPhone上关闭“请勿打扰”

    Apple’s “Do Not Disturb While Driving” is a potentially lifesaving iPhone feature, but it doesn’t always turn on automatically at the appropriate time. For example, you might be a passenger in a moving car, but your iPhone may think you’re the one dri…...

    2022/11/19 21:16:57