用户“root"@“localhost"的访问被拒绝 - 终端，Mac

问题描述

我在尝试访问 mysql 时卡住了.这是我的第一次，所以请耐心等待.

I am stuck when trying to access mysql. It's my first time so please be patient with me.

最初我尝试设置 Ruby 和 Rails 并且一切正常，期望在连接到服务器时拒绝访问，所以我运行了这个命令.

Initially I was try to set up Ruby and Rails and everything worked perfrectly expect access denied when connecting to the server, SO I ran this command.

mysql -uroot -p

我尝试了各种密码，包括将其留空并出现此错误.

I've tried various passwords including leaving it blank and get this error.

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

我假设我需要为 root 用户重置密码，但我似乎无法让它工作.

I am assuming I need to reset the password for root user but I just can't seem to get it to work.

推荐答案

一种方法:

1. 停止您的 MySQL 服务器.

2. 使用 --skip-grant-tables 选项启动您的 MySQL 服务器.它允许您无需密码即可连接到服务器.

1. stop your MySQL server.

2. start your MySQL server with the --skip-grant-tables option. It allows you to connect to the server without a password.

/path/to/mysqld --skip-grant-tables &

mysql

UPDATE mysql.user SET password=PASSWORD('NewPassord') WHERE user='root';