如题目所知,我这几天把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';