Snow Leopard:MySQL 无法启动

Snow Leopard:MySQL 无法启动

我已经更新到 Snow Leopard,并且按照此帖子删除了 mysql:http://forums.mysql.com/read.php?11,75256,255853#msg-255853

之后我安装了 mysql 64 位社区版,但使用 prefpane MySQL 无法启动。

使用终端可以为我们提供更多信息,但我不知道如何解释它们:

stefansmac:~ stefan$ cd /usr/local/mysql-5.1.42-osx10.5-x86_64/bin/
stefansmac:bin stefan$ sudo ./mysqld_safe
100105 13:56:35 mysqld_safe Logging to '/usr/local/mysql-5.0.51b-osx10.5-x86//stefansmac.local.err'.
100105 13:56:35 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql-5.0.51b-osx10.5-x86/
100105 13:56:35 mysqld_safe mysqld from pid file /usr/local/mysql-5.0.51b-osx10.5-x86//stefansmac.local.pid ended

此致

答案1

将 /usr/local/mysql/bin 路径添加到 PATH 后,执行 ./mysqld 时出现以下错误

100105 14:14:11 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/mysql-5.0.51b-osx10.5-x86/ is case insensitive
100105 14:14:11 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!

100105 14:14:11 [ERROR] Aborting

100105 14:14:11 [Note] ./mysqld: Shutdown complete

答案2

确保/usr/local/mysql-5.0.51b-osx10.5-x86/目录归用户所有mysql。即:sudo chown -R mysql /usr/local/mysql-5.0.51b-osx10.5-x86/

相关内容