用户“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.
推荐答案
一种方法:
- 停止您的 MySQL 服务器.
使用
--skip-grant-tables
选项启动您的 MySQL 服务器.它允许您无需密码即可连接到服务器.
- stop your MySQL server.
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 客户端连接到您的服务器:
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
相关文章