mysql - 在 Mac OS X 10.6 中启动 MySQL 时出错

Question

我正在尝试在我的 Mac OS X 10.6 (Snow Leopard) 中运行 MySQL 5.5.8。我正在调用/usr/local/mysql/bin/mysqld_safe，我在错误日志中得到了这个...

110124 16:35:36 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql-5.5.8-osx10.6-x86_64/data
110124 16:35:36 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/mysql-5.5.8-osx10.6-x86_64/data/ is case insensitive
110124 16:35:36 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use GCC atomic builtins
InnoDB: Compressed tables use zlib 1.2.3
110124 16:35:36  InnoDB: Initializing buffer pool, size = 128.0M
110124 16:35:36  InnoDB: Completed initialization of buffer pool
110124 16:35:36  InnoDB: highest supported file format is Barracuda.
110124 16:35:36  InnoDB: 1.1.4 started; log sequence number 2809411
110124 16:35:36 [ERROR] Can't start server : Bind on unix socket: Permission denied
110124 16:35:36 [ERROR] Do you already have another mysqld server running on socket: /var/mysql/mysql.sock ?
110124 16:35:36 [ERROR] Aborting

110124 16:35:36  InnoDB: Starting shutdown...
110124 16:35:38  InnoDB: Shutdown completed; log sequence number 2809411
110124 16:35:38 [Note] /usr/local/mysql-5.5.8-osx10.6-x86_64/bin/mysqld: Shutdown complete

110124 16:35:38 mysqld_safe mysqld from pid file /usr/local/mysql-5.5.8-osx10.6-x86_64/data/MyMacPro.local.pid ended

这是我在/etc/my.cnf 中的内容...想知道是否需要添加更多设置。

[client]
socket = /var/mysql/mysql.sock

[mysqld]
socket = /var/mysql/mysql.sock

非常感谢，罗伯特

Answer 1

110124 16:35:36 [ERROR] Can't start server : Bind on unix socket: Permission denied

我们刚刚使用 MySQL 5.5.28 执行了以下操作，为我们解决了绑定(bind)问题。这是必要的，因为 sock 文件写在这里:

sudo chown -R _mysql /var/lib/mysql

我们还做了以下操作，但我不确定是否有必要:

sudo chown -R _mysql /usr/local/mysql