macOS homebrew mysql totally reset root password

当我安装完执行 mysql_secure_installation 想要设置一个密码的时候, 提示我

1

Error: Access denied for user 'root'@'localhost' (using password: YES)

这就尼玛离谱了, 还好找到了一个破罐子破摔的方法

1
2
3
4
5
6
7
8
9


brew services stop mysql
pkill mysqld
rm -rf /usr/local/var/mysql/ # NOTE: this will delete your existing database!!!
brew postinstall mysql
brew services restart mysql
mysql -uroot

ALTER USER 'root'@'localhost' IDENTIFIED BY '新密码';
exit