MAC使用mysql报错:ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

时间:2023-03-09 07:44:55
MAC使用mysql报错:ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

遇到这种错误,需要重置密码。

Step1:停止mysql,命令如下:

$ sudo service mysql stop
或者是
$ sudo /usr/local/mysql/support-files/mysql.server stop

Step2:启动安全模式,命令如下:

$ sudo mysqld_safe --skip-grant-tables --skip-networking

Step3:打开一个新的shell/terminal 窗口,进行无密码登录,'password'为需要新设置的密码:

$ mysql -u root
mysql> UPDATE mysql.user SET Password=PASSWORD('password') WHERE User='root';  

新版mysql的命令为:

$ mysql -u root
mysql> UPDATE mysql.user SET authentication_string =PASSWORD('password') WHERE User='root';

Step4:重启mysql,命令如下:

$ sudo service mysql start
或者是
$ sudo /usr/local/mysql/support-files/mysql.server start

大功告成!