雪豹启动mysql错误

我想你的my.cnf文件中有错误。

尝试使用一个stock my.cnf文件或在[mysqld]部分下为用户、pid文件、port、basedir、datadir、tmpdir添加选项(以下是Linux机器上基本mysqld设置的报价,对于OS X可能是这样) this 将有帮助)

[mysqld]
#
# * Basic Settings
#

user        = mysql
pid-file    = /var/run/mysqld/mysqld.pid
socket      = /var/run/mysqld/mysqld.sock
port        = 3306
basedir     = /usr
datadir     = /var/lib/mysql
tmpdir      = /tmp
skip-external-locking

#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address        = 127.0.0.1

Install homebrew package manager with the quick install method http://github.com/mxcl/homebrew

Then from terminal

brew install mysql

and follow the short list of directions that follow the installation

to see the instructions again

brew info mysql

Just in case anyone else runs into this infuriating issue.....

Homebrew install of mysql, snow leopard (most recent update)

确定你的 /usr/local/var/mysql and all subdirs is owned by current user!

sudo chown -R <user> /usr/local/var/mysql

如果您想使用 /etc/my.cnf and you are specifying something like

default-character-set=utf8

your server will never start. I believe MySql 5.5.x has this set by default. Comment this line out in your my.cnf file and mysql.server start should do the trick.

每次加载MySQL时,都应该重新创建该文件,但有时权限会受到阻碍。尝试手动创建/tmp/mysql.sock

On linux the command would be:

sudo touch /tmp/mysqld.sock

Then set the correct owner: sudo chown mysql:mysql /tmp/mysqld.sock

I assume command line on a mac would be the same.

I imagine that some of these other solutions will be appropriate for some other people, but I had all of these same symptoms (including the line 418: pidof: command not found

我有一个工作 /etc/my.cnf 文件突然停止工作,所以我确信问题不是我的配置。结果发现下面有一个子目录 /usr/local/var/mysql/ was owned by _mysql:staff, when it should have been owned by me. 运行后 chown -R 'whoami' /usr/local/var/mysql/ , all was right with the world.

First of all you have to unlock that pid process then. 停止MySQL srvice mysql stop 在那之后,键入这个命令 ps-ef| grep mysql It will show two pid of sql. 杀死双方 kill -9 pid 1 pid2 then start sql by service mysql start .

There seems to be an error message:

line 418: pidof: command not found

你有 pidof 安装? Its manpage 说:

pidof is simply a (symbolic) link to the killall5 program, which should also be located in /sbin

Perhaps the symlink doesn't exist or killall5 is not installed on your Mac OS?

http://dev.mysql.com/doc/refman/5.5/en/mysql-server.html

Quoting David Tonhofer:

And also add
-----------
echo "Manager PID file is $pid_file, Server PID file is $server_pid_file"
-----------
directly before the line 'case "$mode" in'
for some great debugging justice.

我最初的猜测是mysqld没有更新/删除其pid文件的权限,可能还有一个剩余的pid文件需要手动删除。但“伟大的调试正义”听起来太好了,不容错过。:)

Try to install it as a part of MAMP . 这将在不同的位置(applications/mamp/mysql以及apache等)安装一个mysql服务器,然后您可以使用这个小部件来启动它。您还可以使用活动监视器(应用程序/实用程序)来监视活动。此外:

Deleting: /Applications/MAMP/tmp/mysql/mysql.pid

and restarting does help often.

高温高压

If you installed view homebrew, try

unset TMPDIR
mysql_install_db