Mac mysql 8.0.21 Homebrew 找回密码语句 You have an error in your SQL syntax；

进入mysql 按照其他文章就可以
使用 brew 安装的 mysql 8.0.21 语句用这个

use mysql;

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';

flush privileges;
quit;