如果你電腦是mac的，使用homebrew安裝安裝是一個非常便捷的方式，但是還是會出現(xiàn)一些問題。下面通過本文給大家介紹解決mac使用homebrew安裝mysql無法登陸問題,需要的朋友可以參考下
如果你電腦是Mac的，使用homebrew安裝MySQL是一個非常便捷的方式，但是還是會出現(xiàn)一些問題；
首先保證你已經(jīng)安裝了mysql,如果是通過homebrew安裝的，輸入mysql.server start 啟動服務(wù)
如果在輸入
mysql?-u?root
出現(xiàn)這個錯誤ERROR 1045 (28000): Access denied for user ‘zhongchengming’@’localhost’ (using password: YES)，應(yīng)該是修改初始密碼沒有成功
解決步驟
（1）終端輸入mysqld_safe –skip-grant-tables 顯示如下
2017-03-21T11:44:11.6NZ?mysqld_safe?Logging?to?'/usr/local/var/mysql/zhongchengmingdeMacBook-Air.local.err'. 2017-03-21T11:44:11.6NZ?mysqld_safe?Logging?to?'/usr/local/var/mysql/zhongchengmingdeMacBook-Air.local.err'. 2017-03-21T11:44:11.6NZ?mysqld_safe?A?mysqld?process?already?exists
?（2）再次輸入mysql -u root顯示如下
Welcome?to?the?MySQL?monitor.??Commands?end?with?;?or?g. Your?MySQL?connection?id?is?10 Server?version:?5.7.17?Homebrew Copyright?(c)?2000,?2016,?Oracle?and/or?its?affiliates.?All?rights?reserved. Oracle?is?a?registered?trademark?of?Oracle?Corporation?and/or?its affiliates.?Other?names?may?be?trademarks?of?their?respective owners. Type?'help;'?or?'h'?for?help.?Type?'c'?to?clear?the?current?input?statement. mysql>
?? （3）終端輸入 use mysql顯示如下
Reading?table?information?for?completion?of?table?and?column?names You?can?turn?off?this?feature?to?get?a?quicker?startup?with?-A Database?changed mysql>
（4）修改密碼UPDATE mysql.user SET authentication_string=PASSWORD(‘你的密碼’) WHERE User=’root’;
? 成功? Query OK, 1 row affected, 1 warning (0.05 sec)
? Rows matched: 1? Changed: 1? Warnings: 1
? 版權(quán)聲明
文章版權(quán)歸作者所有，未經(jīng)允許請勿轉(zhuǎn)載。
THE END
.png)
