MySQL 重置密码

brew services stop mysql

brew services stop mysql@5.7

% brew info mysql
mysql: stable 8.0.26 (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)
  percona-server (because mysql, mariadb, and percona install the same binaries)
/usr/local/Cellar/mysql/8.0.26 (304 files, 296MB) *
  Poured from bottle on 2022-01-27 at 10:58:20
From: https://github.com/Homebrew/homebrew-core/blob/HEAD/Formula/mysql.rb
License: GPL-2.0-only with Universal-FOSS-exception-1.0
==> Dependencies
Build: cmake ✘, pkg-config ✔
Required: icu4c ✔, libevent ✔, lz4 ✔, openssl@1.1 ✔, protobuf ✔, zstd ✔
==> 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:
  /usr/local/opt/mysql/bin/mysqld_safe --datadir=/usr/local/var/mysql
==> Analytics
install: 92,820 (30 days), 237,270 (90 days), 943,044 (365 days)
install-on-request: 92,437 (30 days), 236,308 (90 days), 937,806 (365 days)
build-error: 418 (30 days)

/usr/local/opt/mysql/bin/mysqld_safe --datadir=/usr/local/var/mysql

ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';

mysqld --init-file=/Users/baoguoxiao/mysql-init --datadir=/usr/local/var/mysql

brew services start mysql