如何找回Homebrew下载的MySQL的密码

我这几天把本机装的MySQL密码给忘记了，于是想办法恢复

• 打开并编辑配置文件my.cnf

  sudo vim /opt/homebrew/etc/my.cnf
  

• 在配置文件添加skip-grant-tables

  # Default Homebrew MySQL server config
  [mysqld]
  skip-grant-tables
  # Only allow connections from localhost
  bind-address = 127.0.0.1
  mysqlx-bind-address = 127.0.0.1
  

• 重启服务

  sudo brew restart mysql
  

• 进入MySQL

  mysql -u root -p
  

• 刷新权限

  FLUSH PRIVILEGES;
  

• 修改账号密码

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