Access denied updating a drive
resulted in the error: "The server quit without updating PID file" I noticed something odd in the installation instructions though.It has ownership changed to mysql for the directory "data", but not to "var"; this is unusual because for years I have had to ensure that var directory was mysql writable.120309 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 120309 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/mysql/data/ is case insensitive 120309 [Warning] You need to use --log-bin to make --binlog-format work. 120309 Inno DB: The Inno DB memory heap is disabled 120309 Inno DB: Mutexes and rw_locks use GCC atomic builtins 120309 Inno DB: Compressed tables use zlib 1.2.3 120309 Inno DB: Initializing buffer pool, size = 16.0M 120309 Inno DB: Completed initialization of buffer pool 120309 Inno DB: Operating system error number 13 in a file operation.Inno DB: The error means mysqld does not have the access rights to Inno DB: the directory.So I just edited /etc/and under the section [mysqld] I added a directive to explicitly point mysql's data directory to var (as I normally expect it to be any how), and after doing so, mysqld starts up just fine.The directive to add looks like this: datadir = /usr/local/mysql/var Worked for me. I had this problem while trying to brew upgrade on Mac OS X 10.7.5.
# # Server Root: The top of the directory tree under which the server's # configuration, error, and log files are kept.
If not a bad config setting, the error log should at least point you in the right direction.
Well, I assume the OP has fixed it at this point...
In the end, cleaning up and following brew doctors advice made it possible to run through the setup described above. I copied the entire lampp folder from /opt to a new server.
So a note to anyone else passing by; don't try to cheat the brew doctor and think you know better! When I tried to start up mysql I got a message: The server quit without updating PID file.