如标题所示,当我尝试从终端启动MySQL时收到错误:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/Applications/MAMP/tmp/mysql/mysql.sock' (2)
我在运行时收到此错误:
/Applications/MAMP/Library/bin/mysql -u root -p
我在运行时没有收到此错误:
mysql -u root -p
但是问题是当我运行的时候 mysql -u root -p
它连接到错误的MySQL ...
killall -9 mysqld
或者 killall mysqld
然后再尝试一切(有意义)。但我没有成功。 此外,我看到你们还应运行其他两个命令以进行调试,虽然我不知道它们的含义,但我知道它返回了
ps -u mysql
UID PID TTY TIME CMD
和返回的
ps -awwx | grep mysql
8001 ?? 0:00.03 /bin/sh /usr/local/opt/mysql/bin/mysqld_safe --bind-address=127.0.0.1 --datadir=/usr/local/var/mysql
16527 ?? 0:00.43 /usr/local/Cellar/mysql/5.6.21/bin/mysqld --basedir=/usr/local/Cellar/mysql/5.6.21 --datadir=/usr/local/var/mysql --plugin-dir=/usr/local/Cellar/mysql/5.6.21/lib/plugin --bind-address=127.0.0.1 --log-error=/usr/local/var/mysql/MacBook-Pro.local.err --pid-file=/usr/local/var/mysql/MacBook-Pro.local.pid
81182 ?? 0:00.04 /bin/sh /Applications/MAMP/Library/bin/mysqld_safe --port=8889 --socket=/Applications/MAMP/tmp/mysql/mysql.sock --pid-file=/Applications/MAMP/tmp/mysql/mysql.pid --log-error=/Applications/MAMP/logs/mysql_error_log
18520 ttys002 0:00.00 grep mysql