Mac 重置mysql密码

1.关闭mysql

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

2.进入mysql

cd /usr/local/mysql/bin

3.以安全模式进入mysql

./mysqld_safe --skip-grant-tables &

4.重设密码

SET PASSWORD FOR 'root'@'localhost'=PASSWORD('12345678')

如果提示出错

 

使用下面重设密码

SET PASSWORD FOR root@localhost='12345678';