Mac brew 安装mysql8.0 忘记root密码 重置

# 查找mysql进程，查看mysql安装路径
ps -ef | grep mysql
# 进入mysql安装路径 /usr/local/Cellar/mysql/8.0.11/bin （每个人可能不一样）
cd /usr/local/Cellar/mysql/8.0.11/bin
# 暂停mysql服务 ./mysql.server stop # 安全模式启动mysql ./mysqld_safe --skip-grant-tables &
./mysql.server start # 进入mysql交互模式 mysql

use mysql
flush privileges;
ALTER USER 'root'@'localhost' IDENTIFIED BY '新密码';

# 注意：重启mysql
./mysql.server stop
./mysql.server start


转载 https://blog.csdn.net/weixin_42118129/article/details/81177101

转载于:https://www.cnblogs.com/chenjingxuan/p/9528299.html