mysql：ERROR 1045 (28000): Access denied for user @‘localhost‘

1. 停止mysql服务

sudo /usr/local/mysql/support-files/mysql.server stop

2. 用安全模式进入mysql

sudo mysqld_safe --skip-grant-tables

3. 重开一个terminal窗口，在新窗口中执行命令，保持原有窗口打开状态

mysql -u root

4. 修改密码

update mysql.user set authentication_string=password('root') where user='root';

5. 刷新缓存

FLUSH PRIVILEGES;