MacOs执行SQL出错(mysql)

上次修改过root密码之后，刚启动，执行sql就报错了。

错误是：

Reset MySQL root password using ALTER USER statement after install on Mac

解决办法是：

https://stackoverflow.com/questions/33467337/reset-mysql-root-password-using-alter-user-statement-after-install-on-mac
----

UPDATE mysql.user SET Password=PASSWORD('your_new_password') WHERE User='root';

 

转载于:https://www.cnblogs.com/pyyu/p/8489927.html