用户“root"@“localhost"的访问被拒绝 - 终端，Mac [英] Stuck with Access Denied for user 'root'@'localhost' - Terminal, 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.
推荐答案
一种方法:
- 停止您的 MySQL 服务器.
使用
--skip-grant-tables选项启动您的 MySQL 服务器.它允许您无需密码即可连接到服务器.
- stop your MySQL server.
start your MySQL server with the
--skip-grant-tablesoption. It allows you to connect to the server without a password.
/path/to/mysqld --skip-grant-tables &
使用 mysql 客户端连接到您的服务器:
connect to your server using the mysql client:
mysql
更改root密码(用你想要的替换NewPassord):
UPDATE mysql.user SET password=PASSWORD('NewPassord') WHERE user='root';
重启你的 MySQL 服务器.
restart yout MySQL server.
还有其他方法可以重置 MySQL 根密码:http://dev.mysql.com/doc/refman/5.6/en/resetting-permissions.html
There are others ways to reset the MySQL root password: http://dev.mysql.com/doc/refman/5.6/en/resetting-permissions.html
这篇关于用户“root"@“localhost"的访问被拒绝 - 终端，Mac的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
