mac系統(tǒng)中mysql登錄報(bào)錯(cuò)：Access denied for user 'root'@'localhost' (using password: NO)
1、關(guān)閉MySQL
sudo /usr/local/mysql/support-files/mysql.server start??啟動(dòng)
sudo /usr/local/mysql/support-files/mysql.server stop? 關(guān)閉
sudo /usr/local/mysql/support-files/mysql.server restart 重啟
2、在終端中以管理員權(quán)限啟動(dòng)mysqld_safe纵寝，命令如下：
cd /usr/local/mysql/bin
sudo su
./mysqld_safe --skip-grant-tables
3狭瞎、不要關(guān)閉當(dāng)前的終端窗口闻书，新建一個(gè)終端窗口（command+n）趾诗，輸入如下命令痹届，回車登錄mysql
/usr/local/mysql/bin/mysql
4、重置密碼
MySQL 8.0以下
set password for 'root'@'localhost'=password("1234");
MySQL 8.0以上
alter user 'root'@'localhost' identified by '1234';
5笛粘、刷新并退出趁怔。
flush privileges;
quit;
