摘要：經(jīng)常不斷的遇到在上使用這個包管理神器安裝出問題，今天在百度谷歌上搜索資料解決方案今天總算解決掉了，把這個解決方案分享出來我的系統(tǒng)是準(zhǔn)備安裝的是開始之前，假設(shè)你的已經(jīng)安裝好并可以使用。

經(jīng)常不斷的遇到在mac上使用brew這個包管理神器安裝mysql出問題，今天在百度谷歌上搜索資料解決方案今天總算解決掉了，把這個解決方案分享出來

我的系統(tǒng)是 Mac OS X 10.12,準(zhǔn)備安裝的是 mysql 5.7.9
開始之前，假設(shè)你的brew已經(jīng)安裝好并可以使用。

安裝mysql，在終端輸入如下命令并回車：

brew install mysql

等待大概5分鐘（視網(wǎng)速而定）執(zhí)行完畢后，會看到這一段提示：

/usr/local/Cellar/mysql/5.7.9/bin/mysqld --initialize-insecure --user=comet
==> Caveats
We"ve installed your MySQL database without a root password. To secure it run:
    mysql_secure_installation

可以看到brew在安裝的時候已經(jīng)初始過mysql了(不用再像網(wǎng)上說的再執(zhí)行mysql_install_db命令)，且當(dāng)前沒有密碼于是我按照它的提示，執(zhí)行命令:

mysql_secure_installation

需要密碼時，直接回車，出現(xiàn)了如下的錯誤：

Securing the MySQL server deployment.

Enter password for user root:
Error: Access denied for user "root"@"localhost" (using password: NO)

啟動mysql服務(wù)的時候報(bào)錯

mysql.server start
Starting MySQL
... ERROR! The server quit without updating PID file (/usr/local/var/mysql/zhangzhingdeMBP.AirDream.pid).

在谷歌查詢了關(guān)于這個報(bào)錯PID文件的問題解決方案，執(zhí)行下面的命令，（關(guān)于這個報(bào)錯可以參考我的另外一篇文章 ）

sudo rm -rf /usr/local/var/mysql/dev.work.err (dev.work is my hostname)

然后再啟動mysql服務(wù)命令

mysql.server start

提示 .SUCCESS!這時tmp目錄下有mysql.sock這個文件了，于是我繼續(xù)執(zhí)行 mysql_secure_installation

cometdeMacBook-Pro:~ comet$ mysql_secure_installation

Securing the MySQL server deployment.

Connecting to MySQL using a blank password.

VALIDATE PASSWORD PLUGIN can be used to test passwords
and improve security. It checks the strength of password
and allows the users to set only those passwords which are
secure enough. Would you like to setup VALIDATE PASSWORD plugin?

Press y|Y for Yes, any other key for No: N   // 這個選yes的話密碼長度就必須要設(shè)置為8位以上，但我只想要6位的
Please set the password for root here.

New password:            // 設(shè)置密碼

Re-enter new password:     // 再一次確認(rèn)密碼
By default, a MySQL installation has an anonymous user,
allowing anyone to log into MySQL without having to have
a user account created for them. This is intended only for
testing, and to make the installation go a bit smoother.
You should remove them before moving into a production
environment.

Remove anonymous users? (Press y|Y for Yes, any other key for No) : Y    // 移除不用密碼的那個賬戶
Success.


Normally, root should only be allowed to connect from
"localhost". This ensures that someone cannot guess at
the root password from the network.

Disallow root login remotely? (Press y|Y for Yes, any other key for No) : n

 ... skipping.
By default, MySQL comes with a database named "test" that
anyone can access. This is also intended only for testing,
and should be removed before moving into a production
environment.


Remove test database and access to it? (Press y|Y for Yes, any other key for No) : y
 - Dropping test database...
Success.

 - Removing privileges on test database...
Success.

Reloading the privilege tables will ensure that all changes
made so far will take effect immediately.

Reload privilege tables now? (Press y|Y for Yes, any other key for No) : y
Success.

All done!

OK!搞定，可以使用mysql -u root -p 進(jìn)行密碼連接了

PS：以后再也不擔(dān)心此類問題報(bào)錯了，媽媽再也不擔(dān)心我mysql安裝報(bào)錯了