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

2021-12-28 00:00:00 terminal mysql

我在尝试访问 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 客户端连接到您的服务器:

  • 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

    • 相关文章