Mac Mysql mysql_secure_installation Error: Access denied for user 'root'@'localhost' (using password: YES)

標籤：

mysql由brew安裝, 期間好像自動更新了一次

然後再次執行mysql_secure_installation, 輸入root密碼後報錯, 重裝mysql還是不行

 Error: Access denied for user ‘root‘@‘localhost‘ (using password: YES)

原因是之前安裝的mysql設定檔沒有徹底清除

參照 http://stackoverflow.com/questions/4359131/brew-install-mysql-on-mac-os

依次執行

1. brew remove mysql

2. brew cleanup --force

3. rm -rf /usr/local/var/mysql

4. brew install mysql

5. mysql.server start

6. mysql_secure_installation

之前沒執行的步驟是3, 所以只刪除/usr/local/var/mysql然後重新安裝mysql應該也可以, 就不額外測試了

Mac Mysql mysql_secure_installation Error: Access denied for user 'root'@'localhost' (using password: YES)