Mac OS X，MySQL Preference Pane不起作用 [英] Mac OS X, MySQL Preference Pane doesn't work

问题描述

我使用DMG归档文件下载并安装了适用于OS X 10.6的MySQL 5.1.47:

I downloaded and installed MySQL 5.1.47 for OS X 10.6 using the DMG archive:

mysql-5.1.47-osx10.6-x86_64.dmg

我还安装了MySQL.prefPane和MySQLStartupItem.pkg. MySQL.prefPane是首选项窗格.问题是，每当我尝试从首选项"窗格启动/停止MySQL时，系统偏好设置"就会挂起.它永远以大约50％的CPU运行，最终我不得不退出系统偏好设置.如果我切换启动时自动启动MySQL服务器"，也会发生相同的情况.基本上，MySQL Preference Pane不起作用.

I also installed MySQL.prefPane and MySQLStartupItem.pkg. MySQL.prefPane is a Preference Pane. The problem is, whenever I attempt to start/stop MySQL from the Preference Pane, System Preferences just hangs. It runs at about 50% CPU forever, eventually I have for force quit System Preferences. The same thing happens if I toggle "Automatically Start MySQL Server on Startup". Basically the MySQL Preference Pane is not functional.

请注意，我从命令行启动MySQL没问题:

Note that I have no problem starting MySQL from the command line:

sudo /usr/local/mysql/bin/mysqld_safe

我尝试重新安装MySQL和首选项窗格".我使用的是标准安装位置，没有什么不同寻常的.每当MySQL首选项窗格刚刚挂起时.

I have tried reinstalling MySQL and the Preference Pane. I'm using the standard installation location, nothing out of the ordinary. Every time the MySQL Preference Pane just hangs.

我正在运行OS X 10.6.3的Macbook Pro(英特尔)上执行此操作.此计算机上没有旧版本的MySQL.

I'm doing this on a Macbook Pro (Intel) running OS X 10.6.3. There are no old versions of MySQL on this machine.

后续行动:好的，现在是2012年1月，所以我想检查一下是否已解决.我在OS X 10.6.8上尝试了最新的MySQL 5.5.20，但它仍然坏了-相同的行为，它只是挂起(必须强制退出).我尝试了 Jamie Wong的和 carloandaya的建议，都没有用.

Follow-up: Well it's now January 2012 so I figure I'd check to see if this has been fixed. I tried the latest MySQL 5.5.20 on OS X 10.6.8 and it's still broken - same behavior, it just hangs (had to force quit). I tried Jamie Wong's and carloandaya's suggestions, both did not work.

推荐答案

在OS X Lion下，以下对我有用:

Under OS X Lion the following worked for me:

编辑/usr/local/mysql/support-files/mysql.server

edit /usr/local/mysql/support-files/mysql.server

更改线〜46& 47

change lines ~ 46 & 47

basedir=
datadir=

到

basedir=/usr/local/mysql
datadir=/usr/local/mysql/data

这篇关于Mac OS X，MySQL Preference Pane不起作用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！