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