當我們在用MAMP的時候
首先大家要知道,它的mysql程式,是在下面的位置
/Applications/MAMP/Library/bin/mysql
所以當你用終端機,要下達指令時
若出現這個錯誤訊息時
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock'
你的解法如下
首先先用這個語法
代碼:
ps -awwx | grep mysql
76567 ?? 0:00.28 /Applications/MAMP/Library/bin/mysqld --defaults-file=/Applications/MAMP/tmp/mysql/my.cnf --basedir=/Applications/MAMP/Library --datadir=/Library/Application Support/appsolute/MAMP PRO/db/mysql --plugin-dir=/Applications/MAMP/Library/lib/plugin --user=mysql --tmpdir=/Applications/MAMP/tmp/mysql/tmpdir --pid-file=/Applications/MAMP/tmp/mysql/mysql.pid --socket=/Applications/MAMP/tmp/mysql/mysql.sock --port=3306
/Applications/MAMP/tmp/mysql/my.cnf
所以你接著只要這樣做
代碼:
sudo ln -s /Applications/MAMP/tmp/mysql/mysql.sock /tmp/mysql.sock
這樣就ok囉
2018蘋果iPhone發表會確定9/13凌晨一點舉辦
3 小時前 進 iPhone 最新消息