Mysql PrefPane不工作- OS X

Question

当我试图从PrefPane启动MySQL时，它会询问我的密码，然后一直显示MySQL服务器有红色的stopped。

启动不了。

$ mysqladmin start
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!
$ mysql start
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

当我在进程中搜索mysql时，我看到的是：

$ ps wwaux | grep mysqld | grep -v grep
_mysql           203   0.0  0.5  2518204  19288   ??  S     3:30PM   0:23.25 /opt/local/libexec/mysqld --basedir=/opt/local --datadir=/opt/local/var/db/mysql5 --user=_mysql --log-error=/opt/local/var/db/mysql5/localhost.err --pid-file=/opt/local/var/db/mysql5/localhost.pid --socket=/tmp/mysql.sock --port=3306
root              75   0.0  0.0  2435492    884   ??  S     3:30PM   0:00.04 /bin/sh /opt/local/lib/mysql5/bin/mysqld_safe --datadir=/opt/local/var/db/mysql5 --pid-file=/opt/local/var/db/mysql5/localhost.pid

有什么想法？

Answer 1

事实证明，一个mysqld进程正在运行，并被搁置。所以我就进入Activity Monitor，把它杀了，然后重启它。

它现在可以工作了。

Answer 2

检查MySQL端口是否打开：

telnet localhost 3306

检查mysql.sock文件是否存在，如有必要，请修改权限：

sudo chown _mysql:wheel /tmp/mysql.sock

尝试通过终端停止和启动MySQL：

sudo /Library/StartupItems/MySQLCOM/MySQLCOM stop
sudo /Library/StartupItems/MySQLCOM/MySQLCOM start

如果没有帮助，请尝试重置MySQL超级用户密码和/或重新安装MySQL。