mysql5.7 linux or mac 忘记root密码修改

Stop MySQL

sudo /usr/local/mysql/support-files/mysql.server stop

安全模式启动

sudo mysqld_safe –skip-grant-tables

新开一个窗口

mysql -u root
FLUSH PRIVILEGES;
ALTER USER ‘root’@’localhost’ IDENTIFIED BY ‘password’; //password 即是 你的新密码
\q //退出

重启mysql服务重新进入

sudo /usr/local/mysql/support-files/mysql.server start
mysql -u root -ppassword