kerryprops_bookmarks/工具/mysql/说明.md

==> Downloading https://mirrors.ustc.edu.cn/homebrew-bottles/bottles/icu4c-71.1.arm64_monterey.bottle.tar.gz

######################################################################## 100.0%

==> Downloading https://mirrors.ustc.edu.cn/homebrew-bottles/bottles/libevent-2.1.12.arm64_monterey.bottle.tar.gz

######################################################################## 100.0%

==> Downloading https://mirrors.ustc.edu.cn/homebrew-bottles/bottles/libcbor-0.9.0.arm64_monterey.bottle.tar.gz

######################################################################## 100.0%

==> Downloading https://mirrors.ustc.edu.cn/homebrew-bottles/bottles/libfido2-1.12.0.arm64_monterey.bottle.tar.gz

######################################################################## 100.0%

==> Downloading https://mirrors.ustc.edu.cn/homebrew-bottles/bottles/lz4-1.9.4.arm64_monterey.bottle.tar.gz

######################################################################## 100.0%

==> Downloading https://mirrors.ustc.edu.cn/homebrew-bottles/bottles/protobuf-21.6.arm64_monterey.bottle.tar.gz

######################################################################## 100.0%

==> Downloading https://mirrors.ustc.edu.cn/homebrew-bottles/bottles/zlib-1.2.12_1.arm64_monterey.bottle.tar.gz

######################################################################## 100.0%

==> Downloading https://mirrors.ustc.edu.cn/homebrew-bottles/bottles/xz-5.2.6.arm64_monterey.bottle.tar.gz

######################################################################## 100.0%

==> Downloading https://mirrors.ustc.edu.cn/homebrew-bottles/bottles/zstd-1.5.2.arm64_monterey.bottle.3.tar.gz

######################################################################## 100.0%

==> Downloading https://mirrors.ustc.edu.cn/homebrew-bottles/bottles/mysql-8.0.30_1.arm64_monterey.bottle.tar.gz

######################################################################## 100.0%

==> Installing dependencies for mysql: icu4c, libevent, libcbor, libfido2, lz4, protobuf, zlib, xz and zstd

==> Installing mysql dependency: icu4c

==> Pouring icu4c-71.1.arm64_monterey.bottle.tar.gz

🍺  /opt/homebrew/Cellar/icu4c/71.1: 262 files, 76.8MB

==> Installing mysql dependency: libevent

==> Pouring libevent-2.1.12.arm64_monterey.bottle.tar.gz

🍺  /opt/homebrew/Cellar/libevent/2.1.12: 57 files, 2.1MB

==> Installing mysql dependency: libcbor

==> Pouring libcbor-0.9.0.arm64_monterey.bottle.tar.gz

🍺  /opt/homebrew/Cellar/libcbor/0.9.0: 31 files, 179.9KB

==> Installing mysql dependency: libfido2

==> Pouring libfido2-1.12.0.arm64_monterey.bottle.tar.gz

🍺  /opt/homebrew/Cellar/libfido2/1.12.0: 538 files, 1.3MB

==> Installing mysql dependency: lz4

==> Pouring lz4-1.9.4.arm64_monterey.bottle.tar.gz

🍺  /opt/homebrew/Cellar/lz4/1.9.4: 22 files, 681.3KB

==> Installing mysql dependency: protobuf

==> Pouring protobuf-21.6.arm64_monterey.bottle.tar.gz

🍺  /opt/homebrew/Cellar/protobuf/21.6: 279 files, 19.2MB

==> Installing mysql dependency: zlib

==> Pouring zlib-1.2.12_1.arm64_monterey.bottle.tar.gz

🍺  /opt/homebrew/Cellar/zlib/1.2.12_1: 12 files, 397.9KB

==> Installing mysql dependency: xz

==> Pouring xz-5.2.6.arm64_monterey.bottle.tar.gz

🍺  /opt/homebrew/Cellar/xz/5.2.6: 95 files, 1.5MB

==> Installing mysql dependency: zstd

==> Pouring zstd-1.5.2.arm64_monterey.bottle.3.tar.gz

🍺  /opt/homebrew/Cellar/zstd/1.5.2: 31 files, 2.2MB

==> Installing mysql

==> Pouring mysql-8.0.30_1.arm64_monterey.bottle.tar.gz

==> /opt/homebrew/Cellar/mysql/8.0.30_1/bin/mysqld --initialize-insecure --user=sysadmin --basedir=/opt/homebrew/Cellar/mysql/8.0.30_1 --datadir=/opt/homebrew/var/mysql --tmpdir=/tmp

==> Caveats

We've installed your MySQL database without a root password. To secure it run:

    mysql_secure_installation

  

MySQL is configured to only allow connections from localhost by default

  

To connect run:

    mysql -uroot

  

To restart mysql after an upgrade:

  brew services restart mysql

Or, if you don't want/need a background service you can just run:

  /opt/homebrew/opt/mysql/bin/mysqld_safe --datadir=/opt/homebrew/var/mysql

==> Summary

🍺  /opt/homebrew/Cellar/mysql/8.0.30_1: 312 files, 296.4MB

==> Running `brew cleanup mysql`...

Disable this behaviour by setting HOMEBREW_NO_INSTALL_CLEANUP.

Hide these hints with HOMEBREW_NO_ENV_HINTS (see `man brew`).

==> Caveats

==> mysql

We've installed your MySQL database without a root password. To secure it run:

    mysql_secure_installation

  

MySQL is configured to only allow connections from localhost by default

  

To connect run:

    mysql -uroot

  

To restart mysql after an upgrade:

  brew services restart mysql

Or, if you don't want/need a background service you can just run:

  /opt/homebrew/opt/mysql/bin/mysqld_safe --datadir=/opt/homebrew/var/mysql

用户账号密码设置 还是 stackoverflow 好

https://stackoverflow.com/questions/36099028/error-1064-42000-you-have-an-error-in-your-sql-syntax-want-to-configure-a-pa

mysql -u root
ALTER USER 'root'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'yourpasswd';