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';

 

posted @ 2018-03-01 18:14  py鱼  阅读(208)  评论(0编辑  收藏  举报
点我回主页