如果你忘记了你的密码或者想把它改成你的MySQL:

Start your terminal and enter: sudo su Enter the password for you system Stop your MySQL server: sudo /usr/local/mysql/support-files/mysql.server stop Leave this window open, run second terminal window and enter here: mysql -u root And change your password for MySQL: UPDATE mysql.user SET authentication_string=PASSWORD('new_password') WHERE User='root'; where "new_password" - your new password. You don't need old password for MySQL. Flush, quit and check your new password: FLUSH PRIVILEGES; Close all windows and check your new password for MySQL.

如果你忘记了你的密码或者想把它改成你的MySQL:

Start your terminal and enter: sudo su Enter the password for you system Stop your MySQL server: sudo /usr/local/mysql/support-files/mysql.server stop Leave this window open, run second terminal window and enter here: mysql -u root And change your password for MySQL: UPDATE mysql.user SET authentication_string=PASSWORD('new_password') WHERE User='root'; where "new_password" - your new password. You don't need old password for MySQL. Flush, quit and check your new password: FLUSH PRIVILEGES; Close all windows and check your new password for MySQL.

mysqld_safe --skip-grant-tables
mysql -u root
UPDATE mysql.user SET authentication_string='yourpasswd' WHERE User='root';
FLUSH PRIVILEGES;
ALTER USER 'root'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'yourpasswd';

每次我的MacBook重启时，我都需要这样做。

在终端试试这个:

/usr/local/bin/mysql_secure_installation

您可以手动关闭Mac上的MySQL，通过点击Apple菜单并打开系统首选项。选择“MySQL”首选项面板，然后点击“停止MySQL服务器”按钮停止Mac上的MySQL服务器。

停止MySQL后，需要执行以下步骤。

你需要在skip-grant-tables模式下启动MySQL sudo /usr/local/mysql/support-files / mysql。服务器启动——skip-grant-tables 在您的终端中，输入此命令以刷新现有权限 /usr/local/mysql/bin/mysql 现在需要修改用户密码 mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'newpassword' mysql >退出

然后，您可以转到Apple菜单并打开系统首选项。选择“MySQL”首选项面板，然后点击“停止MySQL服务器”按钮来停止Mac上的MySQL服务器。

最后，您可以再次进入Apple菜单并打开系统首选项。选择“MySQL”首选项面板，然后单击“启动MySQL服务器”按钮启动Mac上的MySQL服务器。

当您登录MySQL终端时，请尝试执行FLUSH PRIVILEGES命令。如果这不起作用，请在MySQL终端中尝试以下命令集

mysql -u root

mysql> USE mysql;
mysql> UPDATE user SET password=PASSWORD("NEWPASSWORD") WHERE User='root';
mysql> FLUSH PRIVILEGES;
mysql> quit

用你想要的任何密码更改NEWPASSWORD。应该都准备好了!

更新:从MySQL 5.7开始，密码字段被重命名为authentication_string。修改密码时，使用以下查询来修改密码。所有其他命令保持不变:

mysql> UPDATE user SET authentication_string=PASSWORD("NEWPASSWORD") WHERE User='root';

请不要使用MySQL 8.0+

mysql> UPDATE mysql.user SET authentication_string='password' WHERE User='root'; 

因为它覆盖了authentication_string，它应该是一个哈希而不是纯文本，而是使用:

mysql> `ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';`