MySQL Ver 8.0.41 for macos14.7密码遗忘
第一步彻底禁止 MySQL 开机自启解决根源brew services stop mysql8.0 brew services stop mysql launchctl disable gui/$(id -u)/com.homebrew.mysql8.0第二步强制杀死 删除锁文件sudo pkill -9 mysqld sudo rm -rf /usr/local/var/mysql/*.lock sudo rm -rf /usr/local/var/mysql/ibdata1.lock第三步用绝对正确的安全模式启动/usr/local/opt/mysql8.0/bin/mysqld \ --skip-grant-tables \ --skip-networking \ --datadir/usr/local/var/mysql第四步新开终端无密码登录mysql -u root第五步强制清空密码 重新设置FLUSH PRIVILEGES; CREATE USER IF NOT EXISTS rootlocalhost; UPDATE mysql.user SET authentication_string WHERE user root; SET GLOBAL validate_password.policy 0; SET GLOBAL validate_password.length 4; ALTER USER rootlocalhost IDENTIFIED BY 123456; FLUSH PRIVILEGES; EXIT;第六步关闭日志窗口并正常启动MySQLbrew services start mysql8.0第七步测试登录成功mysql -u root -p输入第五步中改好的密码123456并回车登录成功