mysql - ERROR 1045 (28000): Access denied for user

2019独角兽企业重金招聘Python工程师标准>>>

mac下brew安装mysql，root用户登录不了

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)`

网上找了下，最终解决办法：

brew services stop mysql
mysqld_safe --skip-grant-tables
mysql
>use mysq;
>UPDATE user SET password=PASSWORD('YOUR_NEW_PASSWORD_HERE') WHERE user = 'root';
>exit;
brew services start mysql

转载于:https://my.oschina.net/yangjiandong/blog/646881